(mysql.info.gz) SCHEMA_PRIVILEGES Table
Info Catalog
(mysql.info.gz) USER_PRIVILEGES Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) TABLE_PRIVILEGES Table
21.1.6 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.
*Standard Name* *`SHOW' name* *Remarks*
`GRANTEE' e.g. 'user'@'host'
`TABLE_CATALOG' `NULL'
`TABLE_SCHEMA'
`PRIVILEGE_TYPE'
`IS_GRANTABLE'
Notes:
* This is a non-standard table. It takes its values from the
`mysql.db' table.
Info Catalog
(mysql.info.gz) USER_PRIVILEGES Table
(mysql.info.gz) INFORMATION_SCHEMA Tables
(mysql.info.gz) TABLE_PRIVILEGES Table
automatically generated byinfo2html