Chapter 15. Security and User Administration

by Paul Jensen

IN THIS CHAPTER

• An Overview of SQL Server Security

• Authentication Methods

• SQL Server Security: Logins

• SQL Server Security: Users

• SQL Server Security: Roles

• Managing SQL Server Logins

• Managing SQL Server Users

• Managing Database Roles

• Managing SQL Server Permissions

• SQL Server Permission Approaches

• Object Owners

• Using Encryption

Managing SQL Server security involves controlling access to SQL Server and access to the databases and the objects they contain, as well as defining permissions for users who will perform administrative tasks. This chapter will examine the SQL Server security model and demonstrate the various ways to implement security.