Snowflake Database - Managing User Access Control and More

Become an expert with Snowflake access control including users, roles, role-based access, privileges and more

4.70 (29 reviews)
Udemy
platform
English
language
Other
category
instructor
195
students
3 hours
content
Jun 2021
last update
$44.99
regular price

What you will learn

User Access Management

Roles and Role Hierarchy

Role-based Access

Privileges and their scope to objects and assignment to roles

Quick ways to improve your Snowflake user access security

Column Security (Data Masking)

Many useful queries

Description

Snowflake’s approach to access control combines aspects from Discretionary Access Control (DAC) where each object has an owner, who can in turn grant access to that object. Also included are aspects from Role-based Access Control (RBAC) where access privileges are assigned to roles, which are in turn assigned to users.

There are key concepts that are necessary in order to understand access control in Snowflake. These include:

Securable objects: Entities to which access can be granted.

Roles: An entity to which privileges can be granted. Roles are in turn assigned to users. Note that roles can also be assigned to other roles, creating a role hierarchy which is a critical concept to understand in Snowflake

Privileges: The ability to perform some action on an object. Multiple distinct privileges may be used to control the granularity of access granted.

Users: A user identity recognized by Snowflake, whether associated with a person or application.

In the Snowflake role-based access model, access to securable objects is allowed via privileges assigned to roles, which are in turn assigned to other roles or users. In addition, each securable object has an owner that can grant access to other roles. This model differs from user-based access control models, where rights and privileges are assigned to each user or group of users. The Snowflake model is designed to provide a significant amount of both control and flexibility.

After completing this course you will have a complete understanding of these concepts and more.


Content

Introduction

Introduction
Defining Some Terms

Access Control (Roles and Privileges)

Privileges - Part 1
Privileges - Part 2
Privileges - Part 3
Privileges - Part 4
Privileges - Part 5
Roles and Role-Based Security Access - Part 1
Roles and Role-Based Security Access - Part 2
Useful Queries - Part 1
Useful Queries - Part 2
Other User Related Queries
Using Power BI to Visualize Your Role-Based Access
Using Snowsight to Visualize Your Role-Based Access (Sort of)

Miscellaneous Related Topics

Initial Snowflake Setup - Part 1
Initial Snowflake Setup - Part 2
A Comment about Row-level Security was not Included in this Course
Column-level Security (Data Masking)
Quick Ways to Improve Your Snowflake Security

Test Your Knowledge

Test Your Knowledge

Screenshots

Snowflake Database - Managing User Access Control and More - Screenshot_01Snowflake Database - Managing User Access Control and More - Screenshot_02Snowflake Database - Managing User Access Control and More - Screenshot_03Snowflake Database - Managing User Access Control and More - Screenshot_04

Reviews

Naidu
April 13, 2022
It is good and very useful for all Snowflake administrators and DBAs. Row-level security needs to be added to the course or publish as a new course.

Charts

Price

Snowflake Database - Managing User Access Control and More - Price chart

Rating

Snowflake Database - Managing User Access Control and More - Ratings chart

Enrollment distribution

Snowflake Database - Managing User Access Control and More - Distribution chart

Related Topics

4083978
udemy ID
5/28/2021
course created date
6/14/2021
course indexed date
Bot
course submited by