SHOW ROLES

The SHOW ROLES command shows the list of roles on a cluster.

Syntax

SHOW ROLES [LIKE 'pattern'];

Output

Column

Description

ROLES

Role name

Remarks

  • LIKE: allows users to find roles matching a specific naming pattern.The pattern can include wildcard characters, such as %, to represent zero or more characters in the search string.

    SHOW ROLES LIKE 'xyz';
  • The information_schema.ROLES view provides metadata about the roles configured within the cluster.

  • A user with the SHOW METADATA or GRANT permission can list all roles. Without these permissions, role visibility follows the general information schema access rules. Refer to Accessing the Information Schema for more information.

Example

SHOW ROLES;
+-------------+
| Roles       |
+-------------+
| role_name_0 |
| role_name_1 |
| role_name_2 |
| role_name_3 |
+-------------+
4 rows in set (0.00 sec)

Related Topics

Last modified:

Was this article helpful?