information_schema系统表——COLUMN_PRIVILEGES

该表提供了有关列权限信息，这些信息来自mysql.columns_priv权限表

The COLUMN_PRIVILEGES table provides information about column privileges. This information comes from the mysql.columns_priv grant table.

INFORMATION_SCHEMA NameSHOW NameRemarksGRANTEE 'user_name'@'host_name' valueTABLE_CATALOG defTABLE_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 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.