- Schema:
GRANTS_TO_ROLES View¶
This Account Usage view can be used to query access control privileges that have been granted to a role.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
CREATED_ON |
TIMESTAMP_LTZ |
Date and time (in the UTC time zone) when the privilege is granted to the role. |
MODIFIED_ON |
TIMESTAMP_LTZ |
Date and time (in the UTC time zone) when the privilege is updated. |
PRIVILEGE |
VARCHAR |
Name of the privilege added to the role. |
GRANTED_ON |
VARCHAR |
Object on which the privilege is granted. |
NAME |
VARCHAR |
Name of the object on which the privilege is granted. |
TABLE_CATALOG |
VARCHAR |
Name of the database for the current table. |
TABLE_SCHEMA |
VARCHAR |
Name of the schema for the current table. |
GRANTED_TO |
VARCHAR |
Either |
GRANTEE_NAME |
VARCHAR |
Identifier for the recipient role (i.e. the role to which the privilege is granted). |
GRANT_OPTION |
BOOLEAN |
|
GRANTED_BY |
VARCHAR |
Identifier for the role that granted the privilege. |
DELETED_ON |
TIMESTAMP_LTZ |
Date and time (in the UTC time zone) when the privilege is revoked. |
GRANTED_BY_ROLE_TYPE |
VARCHAR |
Either |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).