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

10. Account- and Database-Level Privileges

Jessica Megan Larson1  
(1)
Oakland, CA, USA
 
We’ve covered the different privileges that exist in Snowflake, how to think about organizing access, and how to curate roles so that they best work with your organization. Now we’re going to focus on actually allocating privileges to roles in a systematic way at all levels within the database hierarchy. We can allocate access to objects at the highest level – the account level – and we can allocate access at the underlying levels – database, schema, table, row, and column – which we can visualize ...

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.