VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping
SHOW ROLES
Description
The SHOW ROLES statement is used to display all created role information, including role name, included users and permissions.
Syntax
SHOW ROLES
Return Value
| Column | DataType | Note |
|---|---|---|
| Name | string | Role Name |
| Comment | string | Comment |
| Users | string | Included Users |
| GlobalPrivs | string | Global Privileges |
| CatalogPrivs | string | Catalog Privileges |
| DatabasePrivs | string | Database Privileges |
| TablePrivs | string | Table Privileges |
| ResourcePrivs | string | Resource Privileges |
| WorkloadGroupPrivs | string | Workload Group Privileges |
Access Control Requirements
The user executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| GRANT_PRIV | USER or ROLE | This operation can only be performed by users or roles with GRANT_PRIV permissions |
Usage Notes
Doris creates a default role for each user. If you want to display the default role, you can execute the command set show_user_default_role=true;.
Example
- View created roles
SHOW ROLES