SHOW GROUPS FOR ROLE

On this page

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

Last modified: August 18, 2023

Was this article helpful?