Chapter 13 -- Designing and Administering SQL Server 2000 Security

3 4

Chapter 13

Designing and Administering SQL Server 2000 Security

About This Chapter

Security is an integral part of any properly designed database. This chapter introduces you to SQL Server security by presenting a layered model of database security. Following an overview of security, you will learn how to design SQL Server security to accommodate user requirements and to protect the database from unauthorized access. The chapter concludes by presenting the primary tools that you will use to implement and administer database security.

Before You Begin

To complete the lessons in this chapter, you must have:

• SQL Server 2000 Enterprise Edition installed on a Windows 2000 Server computer.
• The ability to log on to the Windows 2000 Server computer and to SQL Server as the Windows 2000 Administrator.
• Completed the exercises in Chapter 3, "Designing a SQL Server Database," Chapter 4, "Implementing SQL Server Databases and Tables," Chapter 5, "Implementing Data Integrity," and Chapter 7, "Managing and Manipulating Data."
• Paper and a pencil to complete part of the exercises.