GRANTS_TO_ROLES View (Account Usage): Match SHOW GRANTS TO ROLE command (Pending)¶
This behavior change is in the 2024_01 bundle.
For the current status of the bundle, refer to Bundle History.
The behavior of the Account Usage GRANTS_TO_ROLES view is as follows:
- Before the change:
The output of the view is not consistent with a SHOW GRANTS TO ROLE command: the view does not list all of the grants to each role.
- After the change:
The output of the view is consistent with a SHOW GRANTS TO ROLE command based on the set of enabled features in your Snowflake account.