Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition

CHAPTER
12	Security System of the Database Engine

In This Chapter

•   Encrypting Data

•   Authentication

•   Schemas

•   Database Security

•   Roles

•   Authorization

•   Change Tracking

•   Data Security and Views

This chapter begins with an overview of the most important concepts of database security. It then discusses the specific features of the security system of the Database Engine.

The following are the most important database security concepts:

•   Data encryption

•   Authentication

•   Authorization

•   Change tracking

Data encryption is the process of scrambling information so that it is incomprehensible until it is decrypted by the intended recipient. The Database Engine supports two different encryption methods. The first one ...