Mar 8, 20231 min read

Script to find role assigned to the user in snowflake

select GRANTEE_NAME AS "USERNAME", ROLE

from SNOWFLAKE.ACCOUNT_USAGE.GRANTS_TO_USERS

where DELETED_ON is null and Role = 'ROLENAME'

and Grantee_name like '%username%'

order by USERNAME;

Recent Posts

select distinct count(query_id) as total_query --,QUERY_TEXT --,DATABASE_NAME --,SCHEMA_NAME --,QUERY_TYPE --,USER_NAME --,ROLE_NAME...

select Total_Elapsed_Time/60000 Total_Time_MINS, Database_name, schema_name, User_name, Role_name, Warehouse_name, Warehouse_size,...

--clone table in snowflake create table orders_clone clone orders;