Information Schema APPLICABLE_ROLES Table
The Information Schema APPLICABLE_ROLES table shows the role authorizations that the current user may use.
It contains the following columns:
| Column | Description | Added |
|---|---|---|
GRANTEE | Account that the role was granted to. | |
ROLE_NAME | Name of the role. | |
IS_GRANTABLE | Whether the role can be granted or not. | |
IS_DEFAULT | Whether the role is the user's default role or not | MariaDB 10.1.3 |
The current role is in the ENABLED_ROLES Information Schema table.
Example
SELECT * FROM information_schema.APPLICABLE_ROLES; +----------------+-------------+--------------+------------+ | GRANTEE | ROLE_NAME | IS_GRANTABLE | IS_DEFAULT | +----------------+-------------+--------------+------------+ | root@localhost | journalist | YES | NO | | root@localhost | staff | YES | NO | | root@localhost | dd | YES | NO | | root@localhost | dog | YES | NO | +----------------+-------------+--------------+------------+
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.
