SHOW ROLES
On this page
Shows the list of roles on a cluster/workspace group.
Syntax
SHOW ROLES [LIKE 'pattern'];
Output
Column |
Description |
---|---|
|
Role name |
Remarks
-
LIKE
: allows users to find roles matching a specific naming pattern.The pattern can include wildcard characters, such as %, to represent zero or more characters in the search string. SHOW ROLES LIKE 'xyz';
-
The information_
schema. ROLES
view provides metadata about the roles configured within the workspace or cluster.
Example
SHOW ROLES;
+-------------+
| Roles |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)
Related Topics
Last modified: August 5, 2025