From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Join today to access over 24,700 courses taught by industry experts.
Access control - Snowflake Tutorial
From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Access control
- 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 a 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 multifactor…
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.