Week 124 – Intermediate

A Fresh Start Part 1

After spending some time in India, the Professor is all about “starting fresh.” Are you ready to help him with this week’s challenge?

Sometimes during our projects or work, we feel the need to reset our accounts and truly “start fresh.” This week, we’re kicking off this journey with Roles.

In the script below, you’ll see how to create custom roles for Snowflake. But your task is to write a single statement that drops every role except the default Snowflake roles:

• ACCOUNTADMIN

• SYSADMIN

• SECURITYADMIN

• USERADMIN

• PUBLIC

We strongly recommend using a trial account for this challenge for obvious reasons.

create role test_role_1_tbd;
create role test_role_2_tbd;
create role test_role_3;

For those looking for a possible extra challenge ; Can you create a query that keeps test_role_3 as well ?

Good luck!

Remember if you want to participate:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
3. Post the URL in the comments of the challenge.