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_TYPEcan 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 ...