© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
J. M. LarsonSnowflake Access Controlhttps://doi.org/10.1007/978-1-4842-8038-6_7

7. Assuming a Primary Role

Jessica Megan Larson1  
(1)
Oakland, CA, USA
 

We’ve covered the different role paradigms, whether functional or team, and we’ve addressed the different privileges Snowflake provides. We’ve discussed how we can draft roles so that they are manageable and scalable. Now we’re going to cover how we actually use these roles in practice.

Snowflake is based on role-based access control; all objects are owned by roles rather than by individual users. Privileges are granted to roles rather than directly to users. Users can switch between the different roles granted ...

Get Snowflake Access Control: Mastering the Features for Data Privacy and Regulatory Compliance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.