Information Schema APPLICABLE_ROLES Table
You are viewing an old version of this article. View
the current version here.
MariaDB 10.0.5
The APPLICABLE_ROLES table was introduced in MariaDB 10.0.5
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 | +----------------+-------------+--------------+------------+
Comments
Comments loading...
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.
