To manage SQL Server security, you set the server login security mode, authorize Windows NT users to access SQL Server, manage SQL Server login IDs, manage database users, manage object and statement permissions, change database ownership, and use the security management tools provided with SQL Server 6.0. This chapter presents the procedures you will use and also provides quick-reference summaries of the tasks you will perform to administer security under each of the three SQL Server login security modes.
To gain a fuller understanding of SQL Server security strategies and the elements that make up SQL Server security, see Chapter 8, Security Concepts.
For more information, choose one of the following topics:
Setting the Server Security Options
Managing Access for Windows NT Groups and Users
Managing Statement Permissions