Outdated Version

You are viewing an older version of this section. View current production version.

SHOW ROLES FOR GROUP

Show roles for a specific group.

SHOW ROLES FOR GROUP group_specification

group_specification:
  group
  [
  	'group_name'
  ]

Output

Column Description
Roles of group group_name Roles of specified group

Example

memsql> SHOW ROLES FOR GROUP 'group_0';
+- -----------------------+
| Roles of group group_0 |
+- -----------------------+
| role_name_0            |
+- -----------------------+
1 row in set (0.00 sec)