Road to Snowflake SnowPro Core Certification: Roles in Snowflake

Fourteenth Chapter: Access Management. Roles in Snowflake

Gonzalo Fernandez Plaza
6 min readOct 19, 2021
Snowflake SnowPro Core Certification: Roles.
Snowflake SnowPro Core Certification: Roles.

Access management is one of the most important security-related features in Snowflake. Depending on the role we give to the users, we can control exactly which functions they can execute. Let’s take a closer look!

  1. Access Management Key Concepts
  2. Default Roles
  3. Roles Encapsulation
  4. Roles Commands
  5. Typical Exam Questions

Remember that all the chapters from the course can be found at the following link:

ACCESS MANAGEMENT KEY CONCEPTS

Access control privileges determine who can access and perform operations on specific objects in Snowflake. The Snowflake approach combines aspects from the following models:

  • Discretionary Access Control (DAC)Each object has an owner who can, in turn, grant access to that object.

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com