Lists roles in the catalog, optionally filtered by a LIKE pattern.
SHOW ROLES [LIKE '<pattern>']## Overview SHOW ROLES returns a row per role. The result includes the role name, role type, whether it is built-in, the inherited parent, and creation timestamp. ## Output | Column | Description | |--------|-------------| | name | Role name | | role_type | Role classification | | is_builtin | Whether the role is built-in (ACCOUNTADMIN and similar) | | inherit | Parent role for inheritance, if any | | created_at | ISO 8601 timestamp | ## Access Control Requires the `ManageRoles` privilege. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
pattern | Optional LIKE pattern. |
SHOW ROLES;SHOW ROLES LIKE 'data_%';