Roles were introduced in MariaDB 10.0.5.
 
Syntax
------ 
SET ROLE { role | NONE }
 
Description
----------- 
The SET ROLE statement enables a role, along with all of its
associated permissions, for the current session. To unset a
role, use NONE .
 
If a role that doesn't exist, or to which the user has not
been assigned, is specified, an ERROR 1959 (OP000): Invalid
role specification error occurs.
 
From MariaDB 10.1.1, an automatic SET ROLE is implicitly
performed when a user connects if that user has been
assigned a default role. See SET DEFAULT ROLE.
 
Example
 
SELECT CURRENT_ROLE;
 
+--------------+
| CURRENT_ROLE |
+--------------+
| NULL |
+--------------+
 
SET ROLE staff;
 
SELECT CURRENT_ROLE;
 
+--------------+
| CURRENT_ROLE |
+--------------+
| staff |
+--------------+
 
SET ROLE NONE;
 
Query OK, 0 rows affected (0.00 sec)
 
SELECT CURRENT_ROLE();
+----------------+
| CURRENT_ROLE() |
+----------------+
| NULL |
+----------------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/set-role/