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

ROLE_TAB_PRIVS

ROLE_TAB_PRIVS displays information about object permissions granted to roles (only roles accessible to the user are displayed). By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 ROLE_TAB_PRIVS columns

Name

Type

Description

role

character varying(128)

Role name.

owner

character varying(128)

Object owner.

table_name

character varying(128)

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

column_name

character varying(128)

Not supported. Its value is NULL.

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

common

character varying(3)

Not supported. Its value is NULL.

inherited

character varying(3)

Not supported. Its value is NULL.