DB_TAB_PRIVS
DB_TAB_PRIVS displays authorization information about all objects accessible to the current user. All users can access this view. 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. |
grantee | character varying(128) | Name of the user or role to which the permission is granted. |
table_schema | character varying(128) | Schema to which an object belongs. |
table_name | character varying(128) | Object name. |
privilege | character varying(40) | Permissions on an object, including USAGE, UPDATE, DELETE, INSERT, CONNECT, SELECT, and EXECUTE. |
grantable | character varying(3) | Specifies whether the grant contains the GRANT option.
|
type | character varying(24) | Object types, including NODE GROUP, COLUMN_ENCRYPTION_KEY, PACKAGE, COLUMN, TABLE, VIEW, SEQUENCE, TYPE, INDEX, DATABASE, DIRECTORY, FOREIGN DATA WRAPPER, FOREIGN SERVER, LANGUAGE, SCHEMA, TEMPLATE, FUNCTION, PROCEDURE, and TABLESPACE. |
hierarchy | character varying(3) | Not supported. The value is NULL. |
common | character varying(3) | Not supported. The value is NULL. |
inherited | character varying(3) | Not supported. The value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
