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