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.

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.

Start your free trial