From the course: Snowflake SnowPro Core Cert Prep
Join today to access over 25,300 courses taught by industry experts.
Access control - Snowflake Tutorial
From the course: Snowflake SnowPro Core Cert Prep
Access control
Understanding access control thoroughly before going into your exam is vital. You will get several questions on this, I'm pretty sure, from listing privileges against database objects to granting and revoking privileges. Now, immediately under that organization object we mentioned a little earlier, there's a Snowflake account here followed by hierarchy of containers, as displayed on the screen. Now, we've got database objects such as tables, views and functions, and stored procedures. They're contained within a schema object, which in turn is contained within the database. Now, privileges exist on objects that can be granted to roles, and then users are assigned to those roles. And that's what's known as the role-based hierarchy and the role-based access control model. So, let's just take a look at what roles come out with a box with Snowflake. So, you've got these five-key roles plus the ORGADMIN role. Now, the ACCOUNTADMIN is the most powerful role available. It administers the…
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.