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