SCHEMA_PRIVILEGES

The SCHEMA_PRIVILEGES view contains information about schema (database) privileges.

Column	Description
GRANTEE	The account to which the privilege is granted, in 'user_name'@'host_name' format.
TABLE_CATALOG	The catalog to which the schema belongs. This value is always def.
TABLE_SCHEMA	The name of the schema.
PRIVILEGE_TYPE	The granted privilege.
IS_GRANTABLE	Indicates whether the user has the GRANT OPTION privilege: YES if they do, NO if not. This doesn’t list GRANT OPTION as a separate row.

Note

The SCHEMA_PRIVILEGES view is a nonstandard INFORMATION_SCHEMA view.

For more information, see the MySQL documentation: The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table.