Chapter 5. SQL Server Logins, Roles, and Users

Exam objectives in this chapter:

  • Manage logins and server roles.

  • Manage users and database roles.

Understanding how to assign appropriate permissions to security principals is critical for database administrators. Many find understanding the differences among SQL logins, users, and roles to be difficult. This is because many have come from a background in server administration in which the terms login and user are used interchangeably. In this chapter, you learn about the difference between logins and users and between database roles and server roles. You also learn about contained users, a feature new in SQL Server 2012, and why you might want to implement this new feature.

Lessons in this chapter:

Get Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.