The ENABLED_ROLES
table was introduced in MariaDB 10.0.5
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().
SELECT * FROM information_schema.ENABLED_ROLES; +-----------+ | ROLE_NAME | +-----------+ | NULL | +-----------+ SET ROLE staff; SELECT * FROM information_schema.ENABLED_ROLES; +-----------+ | ROLE_NAME | +-----------+ | staff | +-----------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-enabled_roles-table/