Get startedGet started for free

Role-based Access Control — Question 2

Run the command SELECT CURRENT_USER; to see your username, and then use the GRANT ROLE ... TO USER command to grant the tasty_role role to your username. Then use the USE ROLE command to switch to the role tasty_role. Finally, in the tasty_role role, use the CREATE WAREHOUSE command to create a warehouse called tasty_test_wh. What do you see in the Results?

This exercise is part of the course

Intro to Snowflake for Devs, Data Scientists, Data Engineers

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise