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.