The Information Schema SCHEMA_PRIVILEGES table contains information about database privileges.
It contains the following columns:
| Column | Description |
|---|---|
GRANTEE |
Account granted the privilege in the format user_name@host_name. |
TABLE_CATALOG |
Always def
|
TABLE_SCHEMA |
Database name. |
PRIVILEGE_TYPE |
The granted privilege. |
IS_GRANTABLE |
Whether the privilege can be granted. |
The same information in a different format can be found in the mysql.db table.
© 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-schema_privileges-table/