role_usage_grants

The role_usage_grants view provides information about USAGE privileges granted on various object types.

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.
object_catalog sql_identifier The name of the current database containing the object.
object_schema sql_identifier The name of the schema containing the object.
An empty string is returned if not applicable.
object_name sql_identifier The name of the object.
object_type character_data The name of the object type.
The possible options are:
  • COLLATION
  • DOMAIN
  • FOREIGN DATA WRAPPER
  • FOREIGN SERVER
  • SEQUENCE
privilege_type character_data The type of the privilege.
Always USAGE.
is_grantable yes_or_no Specifies whether the privilege is grantable (YES) or not (NO).