COLUMN_PRIVILEGES

Information on all column privileges that the current authorization identifier has or which it has granted.

Column name

Data type

Contents

GRANTOR

CHAR (18)

Authorization identifier that granted the privilege
or _SYSTEM

GRANTEE

CHAR (18)

Authorization identifier granted the privilege or
PUBLIC

TABLE_CATALOG

CHAR (18)

Database name

TABLE_SCHEMA

CHAR (31)

Name of the schema containing the column to
which the privilege applies

TABLE_NAME

CHAR (31)

Name of the table for whose column the
privilege applies

COLUMN_NAME

CHAR (31)

Name of the column to which the privilege was
restricted

PRIVILEGE_TYPE

CHAR (18)

Privilege type:
SELECT
INSERT
UPDATE
REFERENCES

IS_GRANTABLE

VARCHAR (3)

YES	The authorization identifier has GRANT authorization for the privilege
NO	No GRANT authorization

Table 70: COLUMN_PRIVILEGES view of the INFORMATION_SCHEMA