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.
