Security Concepts

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:

Security Terminology

About the Server Login Security Mode

Windows NT Security and SQL Server

About Server Login IDs

About Database Users

About Permissions

Security and the System Tables