DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) TABLE_PRIVILEGES Table

Info Catalog (mysql.info.gz) SCHEMA_PRIVILEGES Table (mysql.info.gz) INFORMATION_SCHEMA Tables (mysql.info.gz) COLUMN_PRIVILEGES Table
 
 21.1.7 The `INFORMATION_SCHEMA TABLE_PRIVILEGES' Table
 ------------------------------------------------------
 
 The `TABLE_PRIVILEGES' table provides information about table
 privileges.  This information comes from the `mysql.tables_priv' grant
 table.
 
 *Standard Name*               *`SHOW' name*          *Remarks*
 `GRANTOR'                                            omit
 `GRANTEE'                                            e.g. 'user'@'host'
 `TABLE_CATALOG'                                      `NULL'
 `TABLE_SCHEMA'                                       
 `TABLE_NAME'                                         
 `PRIVILEGE_TYPE'                                     
 `IS_GRANTABLE'                                       
 `WITH_HIERARCHY'                                     omit
 
 The following statements are _not_ equivalent:
 
      SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
 
      SHOW GRANTS ...
 
 `PRIVILEGE_TYPE' can contain one (and only one) of these values:
 `SELECT', `INSERT', `UPDATE', `REFERENCES', `ALTER', `INDEX', `DROP',
 `CREATE VIEW'.
 
Info Catalog (mysql.info.gz) SCHEMA_PRIVILEGES Table (mysql.info.gz) INFORMATION_SCHEMA Tables (mysql.info.gz) COLUMN_PRIVILEGES Table
automatically generated byinfo2html