SHOW ROLES

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)