Snowflake Role-based Access Control (RBAC) offers customers powerful tools to configure authorization to secure their systems, including ability to build a hierarchy of roles and assign mix of granular permissions for combined effective permissions. For more information, see Overview of Access Control.

Snowflake Grant Report extracts Roles and Grants data from Snowflake and provides tabular and visual reports on the Role hierarchy and Grant assignments.

Articles:

• Managing Snowflake Roles, Grants, and Privileges with the Snowflake Grant Report Tool
• Auditing Changes in Security Configuration with the Snowflake Grant Report Tool

Take a look at examples from Sample Reports.

Visual representation of Role hierarchy and databases used by those Roles, with Roles color-coded to their type and location within the hierarchy, offering online graph visualization as well PNG, SVG and PDF versions.

For more information, see Role Hiearchy Reports.

All Grants for the TABLE Object Type:

All Grants granted to specific Roles, filtered by Object Type, showing distinct Privileges on those Objects

All Grants for Schema, Table and View object in a Database:

all Roles created over years and months by different Owner Roles:

For more information, see Table Reports.