(mysql.info) table-privileges-table
Info Catalog
(mysql.info) schema-privileges-table
(mysql.info) information-schema
(mysql.info) column-privileges-table
20.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.
*`INFORMATION_SCHEMA' Name* *`SHOW' Name* *Remarks*
`GRANTEE' `'USER_NAME'@'HOST_NAME''
value
`TABLE_CATALOG' `NULL'
`TABLE_SCHEMA'
`TABLE_NAME'
`PRIVILEGE_TYPE'
`IS_GRANTABLE'
Notes:
* `PRIVILEGE_TYPE' can contain one (and only one) of these values:
`SELECT', `INSERT', `UPDATE', `REFERENCES', `ALTER', `INDEX',
`DROP', `CREATE VIEW'.
The following statements are _not_ equivalent:
SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
SHOW GRANTS ...
Info Catalog
(mysql.info) schema-privileges-table
(mysql.info) information-schema
(mysql.info) column-privileges-table
automatically generated byinfo2html