© 2026 LinearBytes Inc.
Search posts, tags, users, and pages
John Ryan
Drawing Pictures, Telling Stories, Explaining Stuff
Show Grants: What does it do? Used to find: Which Users have access to a given Role? Which Users or Roles were granted to a given Role (confusing - but it makes sense below) Which Roles have access to a given Table or View Which Privileges (eg. C...
Serge Shakhov
Hi John, What is MONITOR_GRANT_TO_ROLES? It doesn't exist in my Snowflake databases.
Hey Serge. Really sorry for the typo, I normally create a local temporary table to avoid re-querying the ACCOUNT_USAGE views.
Now amended (and TESTED!) the query.
Thanks for pointing that out. Hope it's useful to you now!
Serge Shakhov
Hi John, What is MONITOR_GRANT_TO_ROLES? It doesn't exist in my Snowflake databases.