SCHEMA_PRIVILEGES table provides
information about schema (database) privileges. It takes its
values from the
mysql.db system table.
SCHEMA_PRIVILEGES table has these
The name of the account to which the privilege is granted, in
The name of the catalog to which the schema belongs. This value is always
The name of the schema.
The privilege granted. The value can be any privilege that can be granted at the schema level; see Section 18.104.22.168, “GRANT Statement”. Each row lists a single privilege, so there is one row per schema privilege held by the grantee.
YESif the user has the
NOotherwise. The output does not list
GRANT OPTIONas a separate row with
SCHEMA_PRIVILEGESis a nonstandard
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.SCHEMA_PRIVILEGES SHOW GRANTS ...