Syntax
------

CURRENT_ROLE, CURRENT_ROLE()

Description
-----------

Returns the current role name. This determines your access privileges. The
return value is a string in the utf8 character set.

If there is no current role, NULL is returned.

The output of SELECT CURRENT_ROLE is equivalent to the contents of the
ENABLED_ROLES Information Schema table.

USER() returns the combination of user and host used to login. CURRENT_USER()
returns the account used to determine current connection's privileges.

Examples
--------

SELECT CURRENT_ROLE;
+--------------+
| CURRENT_ROLE |
+--------------+
| NULL         |
+--------------+

SET ROLE staff;

SELECT CURRENT_ROLE;
+--------------+
| CURRENT_ROLE |
+--------------+
| staff        |
+--------------+

URL: https://mariadb.com/kb/en/current_role/