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

DB_COL_PRIVS

DB_COL_PRIVS displays the following granting information:
  • Column permission granting information when the current user is the object owner, grantor, or grantee.
  • Column permission granting information when the enabled role or PUBLIC role is the grantee.

By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_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
  • NO

common

character varying(3)

Not supported. Its value is NULL.

inherited

character varying(3)

Not supported. Its value is NULL.