The SCHEMA_PRIVILEGES table provides
information about schema (database) privileges. This information
comes from the mysql.db grant table.
INFORMATION_SCHEMA
Name
|
SHOW Name
|
Remarks |
GRANTEE
|
'user_name'@'host_name'
value, MySQL extension |
|
TABLE_CATALOG
|
NULL, MySQL extension |
|
TABLE_SCHEMA
|
MySQL extension | |
PRIVILEGE_TYPE
|
MySQL extension | |
IS_GRANTABLE
|
MySQL extension |
Notes:
-
This is a non-standard table. It takes its values from the
mysql.dbtable.