Role creation issue

Question

I login to my snowflake trial account and changed role to accountadmin. Created new user and role. assigned COMPUTE_WH to new user.

I login to snowflake with new userid but unable to select warehouse or any action. Could you please let me know what is missing.

Thanks, Yash

Answer 1

Good chance that you granted a role to the user and granted the warehouse to the role. However, a new user's default role will be PUBLIC, so when you log into Snowflake using the new user, you need to change their role to the new role that you created. Then, you'll see the warehouse.

You can also go back in as accountadmin and change the default role for the new user to the new role you created.