Chapter 15. Security and User Administration

by Paul Jensen


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

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features