COLUMN_PRIVILEGES table provides
information about column privileges. It takes its values from the
mysql.columns_priv system table.
COLUMN_PRIVILEGES table has these
The name of the account to which the privilege is granted, in
The name of the catalog to which the table containing the column belongs. This value is always
The name of the schema (database) to which the table containing the column belongs.
The name of the table containing the column.
The name of the column.
The privilege granted. The value can be any privilege that can be granted at the column level; see Section 184.108.40.206, “GRANT Statement”. Each row lists a single privilege, so there is one row per column privilege held by the grantee.
In the output from
SHOW FULL COLUMNS, the privileges are all in one column and in lowercase, for example,
COLUMN_PRIVILEGES, there is one privilege per row, in uppercase.
YESif the user has the
NOotherwise. The output does not list
GRANT OPTIONas a separate row with
COLUMN_PRIVILEGESis a nonstandard
The following statements are not equivalent:
SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES SHOW GRANTS ...