Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table

The SCHEMA_PRIVILEGES table provides information about schema (database) privileges. This information comes from the mysql.db grant table. mysql> mysql> desc INFORMATION_SCHEMA.SCHEMA_PRIVILEGES; +----------------+--------------+------+-----+---------+-------+ | Field          | Type         | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | GRANTEE        | varchar(81)  | NO   |     |         |       | | TABLE_CATALOG  | varchar(512) | YES  |     | NULL    |       | | TABLE_SCHEMA   | varchar(64)  | NO   |     |         |       | | PRIVILEGE_TYPE | varchar(64)  | NO   |     |         |       | | IS_GRANTABLE   | varchar(3)   | NO   |     |         |       | +----------------+--------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)