May 2023
Intermediate to advanced
992 pages
31h 14m
English
book
SQL Server 2022 Administration Inside Out
by Randolph West, Melody Zacharias, William Assaf, Deepthi Goguri, Elizabeth Noble, Meagan Longoria, Joseph D'Antoni, Louis Davidson
Content preview from SQL Server 2022 Administration Inside Out
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 12
Administer instance and database security and permissions
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 ...