Information Schema ENABLED_ROLES Table    The Information Schema ENABLED_ROLES table shows the enabled roles for the current session. It contains the following column: 


Column
Description
 
ROLE_NAME
The enabled role name, or NULL.
  
This table lists all roles that are currently enabled, one role per row — the current role, roles granted to the current role, roles granted to these roles and so on. If no role is set, the row contains a NULL value. The roles that the current user can enable are listed in the APPLICABLE_ROLES Information Schema table. See also CURRENT_ROLE(). Examples SELECT * FROM information_schema.ENABLED_ROLES;
+-----------+
| ROLE_NAME |
+-----------+
| NULL      |
+-----------+

SET ROLE staff;

SELECT * FROM information_schema.ENABLED_ROLES;
+-----------+
| ROLE_NAME |
+-----------+
| staff     |
+-----------+
    Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.  

    
{'path': 'public/docs/mariadb/information-schema-enabled_roles-table/index.html', 'source': 'DevDocs.IO'}