Schema:

ACCOUNT_USAGE

GRANTS_TO_USERS View

This Account Usage view can be used to query the roles that have been granted to a user.

Columns

Column Name

Data Type

Description

CREATED_ON

TIMESTAMP_LTZ

Time and date (in the UTC time zone) when the role is granted.

DELETED_ON

TIMESTAMP_LTZ

Time and date (in the UTC time zone) when the role is revoked.

ROLE

VARCHAR

Identifier for the role granted to the user.

GRANTED_TO

VARCHAR

For this view, the value is USER.

GRANTEE_NAME

VARCHAR

Name of the user to whom the privilege is granted.

GRANTED_BY

VARCHAR

Identifier for the role that granted the privilege.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).

  • This view records current grants and historical grants, including grants that were revoked and granted again.