The Information Schema TABLE_PRIVILEGES table contains table privilege information derived from the mysql.tables_priv grant table.
It has the following columns:
| Column | Description |
|---|---|
GRANTEE |
In the format user_name@host_name. |
TABLE_CATALOG |
Always def. |
TABLE_SCHEMA |
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. |
Similar information can be accessed with the SHOW GRANTS statement. See the GRANT article for more about privileges.
For a description of the privileges that are shown in this table, see table privileges.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-table_privileges-table/