O'Reilly logo

Programming Microsoft® SQL Server® 2012 by Leonard Lobel and Andrew Brust

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

SQL Server Security Overview

If you are already familiar with the concepts of users and roles and SQL Server logins, you can probably skip ahead to the next section of this chapter. But for those who aren’t, we’ll provide a quick explanation. The concepts of users and roles exist both in the Microsoft Windows world and in SQL Server. In an abstract sense, they are referred to as principals. Principals are entities that can request resources from the application or an operating system. In the case of Windows, principals are entities such as Domain Users and Groups, and Local Users and Groups. In SQL Server, these entities are logins and server roles. Within a database, these entities are database users, database roles, and application roles, to ...

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