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 schema.
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. Its value is NULL. |
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.