Warning
SingleStore 9.0 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 GROUPS FOR ROLE
On this page
Show groups for a specific role.
Syntax
SHOW GROUPS FOR ROLE role_specification
role_specification:
role
[
ROLE 'role_name'
]
Output
Column |
Description |
---|---|
|
Groups with role |
Example
SHOW GROUPS FOR ROLE 'role_name_0';
+------------------------------+
| Groups with role role_name_0 |
+------------------------------+
| group_0 |
+------------------------------+
1 row in set (0.00 sec)
Related Topics
Last modified: August 18, 2023