Skip to content
Advertisement

Query for all roles with a given privilege grant in Snowflake

Is there any means of querying Snowflake for all the roles (and/or users) where a specific privilege has been granted? I know how to show grants to <role> but I’m not so sure of how to find the roles that have a grant.

This is not something that needs to happen regularly–i’m just looking for ways to better understand this instance and its usage.

Advertisement

Answer

Thanks to Himanshu, I was able to work out a query that answers my question exactly:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement