Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

The INFORMATION_SCHEMA USER_PRIVILEGES Table

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