How can a user see the privileges granted to a particular custom role in Snowflake?
SHOW GRANTS TO ROLE <role_name> lists all privileges and roles that have been granted to the specified role. SHOW GRANTS ON ACCOUNT instead lists account-level privileges granted to roles. See Snowflake’s SHOW GRANTS documentation.
SHOW GRANTS TO ROLE <role_name>
SHOW GRANTS ON ACCOUNT
Community Discussion