role_table_grants

The role_table_grants view provides information about privileges granted on tables or views.

Column name Data type Description
grantor sql_identifier The name of the role that granted the privilege.
grantee sql_identifier The name of the role to which the privilege was granted.
table_catalog sql_identifier The name of the current database containing the table.
table_schema sql_identifier The name of the schema containing the table.
table_name sql_identifier The name of the table.
privilege_type character_data The type of the privilege.
The possible options are:
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • TRUNCATE
  • REFERENCES
  • TRIGGER
is_grantable yes_or_no Specifies whether the privilege is grantable (YES) or not (NO).
with_hierarchy yes_or_no Specifies whether the privilege is SELECT and allows certain operations on table inheritance hierarchies (YES) or not (NO).