Skip to main content

column_privileges

column_privileges identifies all privileges granted on columns to a currently enabled role or by a currently enabled role.

The following fields are provided in column_privileges:

FieldDescription
GRANTEEThe name of the user to which the privilege is granted.
TABLE_CATALOGThe name of the catalog to which the table containing the column belongs. This value is always def.
TABLE_SCHEMAThe name of the database to which the table containing the column belongs.
TABLE_NAMEThe name of the table containing the column.
COLUMN_NAMEThe name of the column.
PRIVILEGE_TYPEThe privilege granted. The value can be any privilege that can be granted at the column level. Each row lists a single privilege, so there is one row per column privilege held by the grantee.
IS_GRANTABLEYES if the user has the GRANT OPTION privilege, NO otherwise. The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT OPTION'.