(mysql.info) schema-privileges-table
Info Catalog
(mysql.info) user-privileges-table
(mysql.info) information-schema
(mysql.info) table-privileges-table
20.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.
*`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.db' table.
Info Catalog
(mysql.info) user-privileges-table
(mysql.info) information-schema
(mysql.info) table-privileges-table
automatically generated byinfo2html