(mysql.info) table-privileges-table

Info Catalog

(mysql.info) schema-privileges-table

(mysql.info) information-schema

(mysql.info) column-privileges-table

 
 20.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.
 
 *`INFORMATION_SCHEMA' Name*   *`SHOW' Name*          *Remarks*
 `GRANTEE'                                            `'USER_NAME'@'HOST_NAME''
                                                      value
 `TABLE_CATALOG'                                      `NULL'
 `TABLE_SCHEMA'                                       
 `TABLE_NAME'                                         
 `PRIVILEGE_TYPE'                                     
 `IS_GRANTABLE'                                       
 
 Notes:
 
    * `PRIVILEGE_TYPE' can contain one (and only one) of these values:
      `SELECT', `INSERT', `UPDATE', `REFERENCES', `ALTER', `INDEX',
      `DROP', `CREATE VIEW'.
 
 The following statements are _not_ equivalent:
 
      SELECT ... FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
 
      SHOW GRANTS ...
 

Info Catalog

(mysql.info) schema-privileges-table

(mysql.info) information-schema

(mysql.info) column-privileges-table