O'Reilly logo

SQL Server 2017 Administration Inside Out, First Edition by Randolph West, William Assaf, Sven Aelterman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required