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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise