USAGE_PRIVILEGES view

In accordance with the ANSI standard, this view displays a row for each privilege defined for sequences in the specified (or current) database.

To view privileges on other types of objects, use the OBJECT_PRIVILEGES view view.

Columns

Column Name

Data Type

Description

GRANTOR

TEXT

Role who granted the usage privilege

GRANTEE

TEXT

Role to whom the usage privilege is granted

OBJECT_CATALOG

TEXT

Database containing the object on which the privilege is granted

OBJECT_SCHEMA

TEXT

Schema containing the object on which the privilege is granted

OBJECT_NAME

TEXT

Name of the object on which the privilege is granted

OBJECT_TYPE

TEXT

Type of the object on which the privilege is granted

PRIVILEGE_TYPE

TEXT

Type of the granted privilege

IS_GRANTABLE

TEXT

Whether the privilege was granted WITH GRANT OPTION

CREATED

TIMESTAMP_LTZ

Creation time of the privilege

Usage notes

  • The view only displays objects for which the current role for the session has been granted access privileges.