You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> SHOW GROUPS FOR ROLE 'role_name_0';
+------------------------------+
| Groups with role role_name_0 |
+------------------------------+
| group_0                      |
+------------------------------+
1 row in set (0.00 sec)

Related Topics