Security is a hot topic today. When it comes to the database level, the consequences can be a lot bigger compared to the classic attack on network resources. This is because when all security elements fail (for instance, installation, authentication, authorization, bad access policy, and so on), all that is left is the data. In other words, if database records containing critical information are not protected, then all security elements are irrelevant.
This chapter is focused on data protection using built-in encryption features in SQL Server on Linux. If you want to prevent and minimize consequences of data breach, then this is the right chapter for you. Also, this chapter will teach you how to protect your data assets from inside threats in the form of internal malicious users.
In this chapter, you will learn the following:
- Crash course in cryptography
- Transparent Data Encryption
- Backup encryption
- Symmetric encryption
- Row-level security
- Dynamic data masking...