usage_privileges

The usage_privileges view provides information about USAGE privileges granted on various database objects.

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.
Empty string – Not applicable.
object_name sql_identifier The name of the object.
object_type sql_identifier The type of the object.
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).