The TABLE_PRIVILEGES table provides information about table privileges.
PRIVILEGE_TYPE can contain one (and only one) of these values: SELECT, INSERT, UPDATE, REFERENCES, ALTER, INDEX, DROP, CREATE VIEW.
This information comes from the mysql.tables_priv grant table.
mysql> mysql> desc INFORMATION_SCHEMA.TABLE_PRIVILEGES; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | GRANTEE | varchar(81) | NO | | | | | TABLE_CATALOG | varchar(512) | YES | | NULL | | | TABLE_SCHEMA | varchar(64) | NO | | | | | TABLE_NAME | varchar(64) | NO | | | | | PRIVILEGE_TYPE | varchar(64) | NO | | | | | IS_GRANTABLE | varchar(3) | NO | | | | +----------------+--------------+------+-----+---------+-------+ 6 rows in set (0.02 sec)
25.8.INFORMATION_SCHEMA | ||||
25.8.1. | The INFORMATION_SCHEMA Database | |||
25.8.2. | The INFORMATION_SCHEMA.SCHEMATA Table | |||
25.8.3. | The INFORMATION_SCHEMA.TABLES Table | |||
25.8.4. | The INFORMATION_SCHEMA.COLUMNS Table | |||
25.8.5. | The INFORMATION_SCHEMA.STATISTICS Table | |||
25.8.6. | The INFORMATION_SCHEMA.USER_PRIVILEGES Table | |||
25.8.7. | The INFORMATION_SCHEMA.SCHEMA_PRIVILEGES Table | |||
25.8.8. | The INFORMATION_SCHEMA.TABLE_PRIVILEGES Table | |||
25.8.9. | The INFORMATION_SCHEMA.COLUMN_PRIVILEGES Table | |||
25.8.10. | The INFORMATION_SCHEMA.CHARACTER_SETS Table | |||
25.8.11. | The INFORMATION_SCHEMA.COLLATIONS Table | |||
25.8.12. | The INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY Table | |||
25.8.13. | The INFORMATION_SCHEMA.TABLE_CONSTRAINTS Table | |||
25.8.14. | The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table | |||
25.8.15. | The INFORMATION_SCHEMA ROUTINES Table | |||
25.8.16. | The INFORMATION_SCHEMA.VIEWS Table | |||
25.8.17. | The INFORMATION_SCHEMA.TRIGGERS Table | |||
25.8.18. | The INFORMATION_SCHEMA.PROFILING Table |