Information Schema SCHEMA_PRIVILEGES Table

The Information Schema SCHEMA_PRIVILEGES table contains information about database-level privileges granted to accounts.

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.

_{This page is licensed: CC BY-SA / Gnu FDL}