Postgres Pro
Downloads
35.37. role_table_grants
Prev UpChapter 35. The Information SchemaHome Next

35.37. role_table_grants

The view role_table_grants identifies all privileges granted on tables or views where the grantor or grantee is a currently enabled role. Further information can be found under table_privileges. The only effective difference between this view and table_privileges is that this view omits tables that have been made accessible to the current user by way of a grant to PUBLIC.

Table 35.35. role_table_grants Columns

Column Type

Description

grantorsql_identifier

Name of the role that granted the privilege

granteesql_identifier

Name of the role that the privilege was granted to

table_catalogsql_identifier

Name of the database that contains the table (always the current database)

table_schemasql_identifier

Name of the schema that contains the table

table_namesql_identifier

Name of the table

privilege_typecharacter_data

Type of the privilege: SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, or TRIGGER

is_grantableyes_or_no

YES if the privilege is grantable, NO if not

with_hierarchyyes_or_no

In the SQL standard, WITH HIERARCHY OPTION is a separate (sub-)privilege allowing certain operations on table inheritance hierarchies. In Postgres Pro, this is included in the SELECT privilege, so this column shows YES if the privilege is SELECT, else NO.


Prev Up Next
35.36. role_routine_grants Home 35.38. role_udt_grants
pdfepub
close