Nov 16, 2026: SHOW GRANTS TO … INCLUDE HIERARCHY (General availability)¶
With this release, you can add INCLUDE HIERARCHY to SHOW GRANTS TO statements to list the grants held by every role in a
grantee’s role hierarchy, not only
the grants made directly to that role or user.
When you specify INCLUDE HIERARCHY, Snowflake expands the roles granted to the specified role or user, including account roles,
database roles, and application roles granted recursively, and the account-level PUBLIC role. Grants held by instance roles,
service roles, or class roles are omitted. Each output row keeps the grantee_name of the role that holds the grant, so you
can see which role in the hierarchy provides a privilege.
You can use INCLUDE HIERARCHY with the following statements:
SHOW GRANTS TO ROLESHOW GRANTS TO DATABASE ROLESHOW GRANTS TO USERSHOW FUTURE GRANTS TO ROLESHOW FUTURE GRANTS TO DATABASE ROLESHOW CALLER GRANTS TO ROLESHOW CALLER GRANTS TO DATABASE ROLE
For more information, see SHOW GRANTS and SHOW CALLER GRANTS.