DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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