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:

ColumnDescriptionAdded
GRANTEEAccount that the role was granted to.
ROLE_NAMEName of the role.
IS_GRANTABLEWhether the role can be granted or not.
IS_DEFAULTWhether the role is the user's default role or notMariaDB 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...