ROLE_TAB_PRIVS
ROLE_TAB_PRIVS displays information about object permissions granted to roles (only roles accessible to the user are displayed). It is accessible to all users. This view exists in the PG_CATALOG and SYS schemas.
| 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. Set it to 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.
|
| common | character varying(3) | Not supported. Set it to NULL. |
| inherited | character varying(3) | Not supported. Set it to NULL. |
