SQL Server 2022 Administration Inside Out

Chapter 12

Administer instance and database security and permissions

• Understand authentication modes

• Grasp security principals

• Understand permissions and authorization

• Perform common security administration tasks

This chapter covers how to implement security when it comes to accessing the data in your databases, starting with authenticating who you are, what you can access, and what you can do with the data once you have access. Many of these principles apply equally to SQL Server and Azure SQL, but there are some differences due to the fundamental nature of each service.

This chapter begins by covering modes to authenticate who the entity is that is trying to access the database. There are several authentication modes that you can use to ...