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

Was this article useful?