(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
automatically generated byinfo2html