DB_COL_PRIVS
- 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 schemas.
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.
|
common |
character varying(3) |
Not supported. Its value is NULL. |
inherited |
character varying(3) |
Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.