Updated on 2024-06-03 GMT+08:00

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.

Table 1 DB_TAB_PRIVS columns

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.

  • YES
  • NO

type

character varying(24)

Object types, including NODE GROUP, COLUMN_ENCRYPTION_KEY, COLUMN, TABLE, VIEW, SEQUENCE, TYPE, INDEX, DATABASE, DIRECTORY, FOREIGN DATA WRAPPER, FOREIGN SERVER, LANGUAGE, LARGE OBJECT, 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.