Microsoft® SQL Server 2008 R2 Unleashed

Chapter 11. Security and User Administration

IN THIS CHAPTER

• What’s New in Security and User Administration

• An Overview of SQL Server Security

• Authentication Methods

• Managing Principals

• Managing Securables

• Managing Permissions

• Managing SQL Server Logins

• Managing SQL Server Users

• Managing Database Roles

• Managing SQL Server Permissions

• The Execution Context

Securing your database environment and providing the right type of access to your users are critical administrative tasks. This chapter examines the security features in SQL Server 2008 that relate to user administration and the objects that users can access.