Chapter 34 -- User and Security Management

3 4

Chapter 34

In this chapter, you'll learn how to manage users and security in a Microsoft SQL Server 2000 environment. Along with backup and recovery planning, sizing, and space management, security management is one of the most common jobs of the DBA. It is also one of the most important tasks that the DBA must perform. If the security of the system is breached, data could be lost or corrupted.

This chapter covers a number of topics related to user and security management. You'll learn how to create and manage user logins and about the modes of authentication; in addition, you'll learn about SQL Server user IDs. A user login is used to authenticate access to SQL Server. The user login can be authenticated through Microsoft Windows NT or Microsoft Windows 2000 or through SQL Server. A user ID is used to assign a user permissions to access specific objects within the individual databases. User IDs are associated with user logins and might or might not consist of the same name, as you'll see later in this chapter. You'll also learn about the types of permissions that can be assigned in SQL Server and how to use them. And you'll learn how to use roles to more easily manage users. Finally you will learn about an important feature in SQL Server 2000 called security account delegation. By the end of this chapter, you'll have the knowledge necessary to manage user logins and security.