Snowflake Access Control: Mastering the Features for Data Privacy and Regulatory Compliance

© 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_4

4. Permission Types

Jessica Megan Larson¹  

(1)

Oakland, CA, USA

 

Gone are the days of simple access control paradigms, at least for data warehouses. We have increasingly complex datasets and as we saw in our last chapter, we have increasingly complex regulations to meet. As a result, we needed to adopt a more robust system of privileges within data warehousing. In order to manage this effectively, we need to thoroughly understand the privileges that exist, and we need to create groupings for the privileges to simplify granting access so that we can manage them at scale. Since these ...