column_privileges

The column_privileges view provides information about column permissions. It takes its values from the m_schema.columns_priv view. This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.column_privileges columns
Name	Type	Description
GRANTEE	varchar(81)	Name of the account to which the permission is granted.
TABLE_CATALOG	varchar(512)	Name of the catalog (database) to which the table containing the column belongs.
TABLE_SCHEMA	varchar(64)	Name of the schema to which the table containing the column belongs.
TABLE_NAME	varchar(64)	Name of the table containing the column.
COLUMN_NAME	varchar(64)	Name of the column.
PRIVILEGE_TYPE	varchar(64)	Permission granted. The value is any permission that can be granted at the column level.
IS_GRANTABLE	varchar(3)	If the user has the GRANT OPTION permission, the value is yes; otherwise, the value is no.