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.