Important
The SingleStore 9.0 release candidate (RC) gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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