Week 124 - Administration

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.

Startup Code

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!