Seriously...
But I am reviewing database security protocols, starting with this article from Oracle
Securing data is the first thing every Data Architect thinks about when setting up a new database, but systems degrade over time, and security becomes more complex, the more data we have.
Snowflake, my database of choice, is particularly challenging because
It is cloud-only
Is accessible to the internet
Requires trust relationships with cloud providers.
Checklists are an excellent method to establish consistency and quality on a repeated process. Security is not a "set it and forget it" process and requires continual diligence and adaptation to change. In that way, it is fundamentally agile: You better be able to respond to change, because the security profile of your data is changing all the time.
In my new initiative, I will be outlining practical checklist and automated methods for Snowflake Data Security including:
Assessment - Build actionable reports on the current state of your data security
Detection - How can you automate intrusion detection
Prevention - How to prevent unauthorized access to data
Data Security - Secure the data at the fundamental levels
User Authentication - Validating the identity of users
User Authorization - Defining Roles and Privileges of users and Groups
It's a large checklist and one I'm hoping will keep me busy writing and learning. Hope you enjoy following me.