(mysql.info.gz) TABLE_PRIVILEGES Table
Info Catalog
(mysql.info.gz) SCHEMA_PRIVILEGES Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) COLUMN_PRIVILEGES Table
21.1.7 The `INFORMATION_SCHEMA TABLE_PRIVILEGES' Table
------------------------------------------------------
The `TABLE_PRIVILEGES' table provides information about table
privileges. This information comes from the `mysql.tables_priv' grant
table.
*Standard Name* *`SHOW' name* *Remarks*
`GRANTOR' omit
`GRANTEE' e.g. 'user'@'host'
`TABLE_CATALOG' `NULL'
`TABLE_SCHEMA'
`TABLE_NAME'
`PRIVILEGE_TYPE'
`IS_GRANTABLE'
`WITH_HIERARCHY' omit
The following statements are _not_ equivalent:
SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
SHOW GRANTS ...
`PRIVILEGE_TYPE' can contain one (and only one) of these values:
`SELECT', `INSERT', `UPDATE', `REFERENCES', `ALTER', `INDEX', `DROP',
`CREATE VIEW'.
Info Catalog
(mysql.info.gz) SCHEMA_PRIVILEGES Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) COLUMN_PRIVILEGES Table
automatically generated byinfo2html