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