Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

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)