Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
SHOW GROUPS FOR ROLE
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 role_name |
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
