From the course: Designing Highly Scalable and Highly Available SQL Databases

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Identify security and compliance requirements

Identify security and compliance requirements

From the course: Designing Highly Scalable and Highly Available SQL Databases

Start my 1-month free trial

Identify security and compliance requirements

- [Instructor] Now, another important factor we need to consider really around any kind of database is security and compliance. Now, when we talk about security, we're really talking about confidentiality of data, availability of that data and maintaining the integrity of it. And basically we want to focus on who can do what to which pieces of data? Now compliance is a little bit different. It's about institutional industry and government policies and laws that really vary by region and industry, but dictate what we can do with data. Now, confidentiality is about limiting access to data to those that need it to do their jobs. Now, this follows from something called the Principle of Least Privilege. The idea here is that anyone doing a particular job working with data or applications, they have all the privileges they need to get their jobs done, but they don't have more. So if you don't need access to a certain set of data…

Contents