| |
23.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.
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 privilege
per row, in uppercase.
PRIVILEGE_TYPE can contain one (and only
one) of these values: SELECT,
INSERT, UPDATE,
REFERENCES.
If the user has GRANT OPTION privilege,
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 ...
|
|
