From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Join today to access over 25,500 courses taught by industry experts.
Access control, users, and roles - Snowflake Tutorial
From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Access control, users, and roles
In this video, we'll discuss how access control works in Snowflake, and a few best practices and important considerations for managing secure access to your Snowflake accounts and Snowflake objects. Here is the Snowflake object hierarchy. This object hierarchy is something that we are familiar with. All of these are securable objects in Snowflake, which means you can grant privileges, and specific kinds of access to roles and users for these individual objects. Snowflake uses role-based access control. Privileges are grouped into roles and roles are assigned to users. Roles can also be assigned to other roles, setting up a role hierarchy. Now, every account in Snowflake has one user who is designated as the account administrator. The Account Administrator is granted the system-defined Account Admin role, and this is an all-powerful role. The recommendation is to have each Account Administrator enable multi-factor authentication for login. So login using the username, password, and one…
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.