Outdated Version
You are viewing an older version of this section. View current production version.
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
