24.28 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
TABLE_PRIVILEGES table provides information about table privileges. It takes its values from the
mysql.tables_priv system table.
TABLE_PRIVILEGES table has these columns:
The name of the account to which the privilege is granted, in
The name of the catalog to which the table belongs. This value is always
The name of the schema (database) to which the table belongs.
The name of the table.
The privilege granted. The value can be any privilege that can be granted at the table level; see Section 188.8.131.52, “GRANT Statement”. Each row lists a single privilege, so there is one row per table privilege held by the grantee.
TABLE_PRIVILEGESis a nonstandard
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES SHOW GRANTS ...