Updated on 2024-05-07 GMT+08:00

MY_COL_PRIVS

MY_COL_PRIVS displays the column permission granting information of the current user as the object owner, grantor, or grantee. By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_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.