Updated on 2024-05-07 GMT+08:00

ADM_TAB_PRIVS

ADM_TAB_PRIVS displays authorization information about all objects in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

Table 1 ADM_TAB_PRIVS columns

Name

Type

Description

grantee

character varying(128)

Name of the user or role to which the permission is granted.

owner

character varying(128)

Object owner.

table_name

character varying(128)

Name of an object. Object types include tables, packages, indexes, and sequences.

grantor

character varying(128)

Name of the user who grants the permission.

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, 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.