SingleStore Managed Service

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