Product Solutions Support
Try MemSQL

SHOW GROUPS FOR ROLE

Show groups for a specific role.

SHOW GROUPS FOR '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)
Was this article useful?