The INFORMATION_SCHEMA.TABLE_PRIVILEGES Table : INFORMATION_SCHEMA : Data Dictionary MySQL TUTORIALS

MySQL TUTORIALS » Data Dictionary » INFORMATION_SCHEMA »

The INFORMATION_SCHEMA.TABLE_PRIVILEGES Table

The TABLE_PRIVILEGES table provides information about table privileges.

PRIVILEGE_TYPE can contain one (and only one) of these values: SELECT, INSERT, UPDATE, REFERENCES, ALTER, INDEX, DROP, CREATE VIEW.

This information comes from the mysql.tables_priv grant table.


mysql>
mysql> desc INFORMATION_SCHEMA.TABLE_PRIVILEGES;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| GRANTEE        | varchar(81)  | NO   |     |         |       |
| TABLE_CATALOG  | varchar(512) | YES  |     | NULL    |       |
| TABLE_SCHEMA   | varchar(64)  | NO   |     |         |       |
| TABLE_NAME     | varchar(64)  | NO   |     |         |       |
| PRIVILEGE_TYPE | varchar(64)  | NO   |     |         |       |
| IS_GRANTABLE   | varchar(3)   | NO   |     |         |       |
+----------------+--------------+------+-----+---------+-------+
6 rows in set (0.02 sec)