MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
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.