From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Join today to access over 24,700 courses taught by industry experts.
Creating users and viewing grants - Snowflake Tutorial
From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Creating users and viewing grants
- In this demo, we'll see how you can create a new user for your Snowflake Account, assign a role to that user, and grant specific privileges to that role. So that the user that you have created can perform the operations that you want them to. In all of the demos that we've performed so far, our user has been operating under the account admin role. If you look on the top right, you can see that the current role is account admin. This is the most powerful role in the system. The account administrator is responsible for configuring parameters at the account level, but if you're actually using a Snowflake you want to use the principle of least privileged, and give users only those privileges that they need. Let's go ahead and select the current role. This function will give you the current role under which your user is operating, and you can see that is account admin. If you click on the dropdown off to the top right, you'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.