(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