(mysql.info.gz) COLUMN_PRIVILEGES Table

Info Catalog

(mysql.info.gz) TABLE_PRIVILEGES Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) CHARACTER_SETS Table

 
 21.1.8 The `INFORMATION_SCHEMA COLUMN_PRIVILEGES' Table
 -------------------------------------------------------
 
 The `COLUMN_PRIVILEGES' table provides information about column
 privileges.  This information comes from the `mysql.columns_priv' grant
 table.
 
 *Standard Name*               *`SHOW' name*          *Remarks*
 `GRANTOR'                                            omit
 `GRANTEE'                                            e.g. 'user'@'host'
 `TABLE_CATALOG'                                      `NULL'
 `TABLE_SCHEMA'                                       
 `TABLE_NAME'                                         
 `COLUMN_NAME'                                        
 `PRIVILEGE_TYPE'                                     
 `IS_GRANTABLE'                                       
 
 Notes:
 
    * In the output from `SHOW FULL COLUMNS', the privileges are all in
      one field and in lowercase, for example,
      `select,insert,update,references'.  In `COLUMN_PRIVILEGES', there
      is one row per privilege, and it's uppercase.
 
    * `PRIVILEGE_TYPE' can contain one (and only one) of these values:
      `SELECT', `INSERT', `UPDATE', `REFERENCES'.
 
    * If the user has `GRANT OPTION' privilege, then `IS_GRANTABLE'
      should be `YES'. Otherwise, `IS_GRANTABLE' should be `NO'.  The
      output does not list `GRANT OPTION' as a separate privilege.
 
 
 The following statements are _not_ equivalent:
 
      SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES
 
      SHOW GRANTS ...
 

Info Catalog

(mysql.info.gz) TABLE_PRIVILEGES Table

(mysql.info.gz) INFORMATION_SCHEMA Tables

(mysql.info.gz) CHARACTER_SETS Table