CURRENT_ROLE()

Grammar Description

Returns the role of the current session.

Grammar Structure

SELECT CURRENT_ROLE();

Example

mysql> select current_role();
+---------------------+
| current_role() |
+---------------------+
| moadmin |
+---------------------+
1 row in set (0.00 sec)

-- Create a new role and switch to a new role
create role use_role_1;
grant all on database * to use_role_1;
grant use_role_1 to root;
set role use_role_1;
mysql> select current_role();
+---------------------+
| current_role() |
+---------------------+
| use_role_1 |
+---------------------+
1 row in set (0.00 sec)