Updated on 2024-06-03 GMT+08:00

ADM_COL_PRIVS

ADM_COL_PRIVS displays permission granting information about all columns. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

Table 1 ADM_COL_PRIVS columns

Name

Type

Description

grantor

character varying(128)

Name of the user who grants the permission.

owner

character varying(128)

Object owner.

grantee

character varying(128)

Name of the user or role to which the permission is granted.

table_schema

character varying(128)

Schema of an object.

table_name

character varying(128)

Object name.

column_name

character varying(128)

Column name.

privilege

character varying(40)

Permission on a column.

grantable

character varying(3)

Specifies whether to grant privileges.

  • YES: The privileges are granted.
  • NO: The privileges are not granted.

common

character varying(3)

Not supported. Its value is NULL.

inherited

character varying(3)

Not supported. Its value is NULL.