Microsoft® SQL Server 2005 Unleashed

Chapter 10. 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 is a critical administrative task. This chapter examines the security features in SQL Server 2005 that relate to user administration and the objects that users can access.

What’s New in Security and User Administration

There have been some significant changes to the security model in SQL Server 2005. These changes are geared ...