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 |
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