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)	Object name. 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.