Roles were introduced in MariaDB 10.0.5.
 
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/