SHOW ROLES

Lists the meta information of the roles created under your account, including role name, creator, creation time, and comments.

Description

Lists the meta information of the roles created under your account, including role name, creator, creation time, and comments.

Note: To query the role you are currently using, use the select current_role() statement.

Syntax

> SHOW ROLES [LIKE 'pattern'];

Examples

-- Show the roles currently under your account
mysql> show roles;
+-----------+---------+---------------------+----------+
| ROLE_NAME | CREATOR | CREATED_TIME        | COMMENTS |
+-----------+---------+---------------------+----------+
| moadmin   |       0 | 2023-04-19 06:37:58 |          |
| public    |       0 | 2023-04-19 06:37:58 |          |
+-----------+---------+---------------------+----------+
2 rows in set (0.01 sec)

-- create a new role named rolex
mysql> create role rolex;
Query OK, 0 rows affected (0.02 sec)

-- Show the roles currently under your account
mysql> show roles;
+-----------+---------+---------------------+----------+
| ROLE_NAME | CREATOR | CREATED_TIME        | COMMENTS |
+-----------+---------+---------------------+----------+
| rolex     |       1 | 2023-04-19 06:43:29 |          |
| moadmin   |       0 | 2023-04-19 06:37:58 |          |
| public    |       0 | 2023-04-19 06:37:58 |          |
+-----------+---------+---------------------+----------+
3 rows in set (0.01 sec)

-- Query the role you are currently using
mysql> select current_role();
+----------------+
| current_role() |
+----------------+
| moadmin        |
+----------------+
1 row in set (0.00 sec)