SQL Server security protects a server and the data stored on that server. SQL Server security determines who can log on to the server; the administrative tasks each user is allowed to perform; which databases, database objects, and data each user can access; and much more.
This chapter provides an orientation to SQL Server 6.0 security elements and concepts. It provides a summary list of SQL Server security terms; explains the three server login security modes; discusses how SQL Server integrates with security for Windows NT–based domains and computers; and describes SQL Server logins, database users, and object and statement permissions.
Use this chapter to gain a fuller understanding of the elements that make up SQL Server 6.0 security. To learn about the procedures you will perform to manage SQL Server 6.0 security and the tools you will use to perform those procedures, see Chapter 9, Managing Security.
For information on security concepts, choose one of the following topics:
About the Server Login Security Mode
Windows NT Security and SQL Server
Security and the System Tables