Chapter 6Administering security and permissions
In this chapter, we look at the Microsoft SQL Server permissions, from authentication through to data access, starting from the ground floor on up. We discuss practical administrative tasks that DBAs need to do and why, including handling orphaned security identifiers (SIDs), security migration, SQL Server Agent runtime permissions, and more. Many of these principles apply equally to SQL Server and Microsoft Azure SQL Database; when they differ, we will point this out.
Logins and users
Given that we’re starting on the ground floor of security, let’s begin by establishing an important distinction in terminology: ...
Get SQL Server 2017 Administration Inside Out, First Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
