The Information Schema TABLE_PRIVILEGES table lists privileges granted specifically at the table level.
The Information Schema TABLE_PRIVILEGES table contains table privilege information derived from the mysql.tables_priv grant table.
It has the following columns:
GRANTEE
In the format user_name@host_name.
TABLE_CATALOG
Always def.
TABLE_SCHEMA
Similar information can be accessed with the statement. See the article for more about privileges.
The table only shows privileges granted on the table level. This differs from the Sys Schema , which shows all privileges, broken down by table.
For a description of the privileges that are shown in this table, see .
This page is licensed: CC BY-SA / Gnu FDL
Database name.
TABLE_NAME
Table name.
PRIVILEGE_TYPE
One of SELECT, INSERT, UPDATE, REFERENCES, ALTER, INDEX, DROP or CREATE VIEW.
IS_GRANTABLE
Whether the user has the GRANT OPTION for this privilege.