Clark Perucho
Apr 23, 2022

Thanks for sharing your solution Milind. However since you have the SECURITYADMIN role, would it not be easier to grant yourself access to SNOWFLAKE database so you can query the ACCOUNT_USAGE.GRANTS_TO_USERS View?

ie.
use role SECURITYADMIN;
grant imported privileges on database SNOWFLAKE to role MYROLE;

use role MYROLE;
select * from snowflake.account_usage.grants_to_users;

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Clark Perucho
Clark Perucho

Written by Clark Perucho

Snowflake Data Superhero | Certified SnowPro: Administrator | Teradata 14 Certified Technical Specialist

Responses (1)

Write a response

Thanks for your feedback Clark. The solution provided by you would totally work too. However in our case; our ACCOUNTADMIN didn't want the access on account_usage views to be granted to any other role. So we came up with the approach which I shared.