Chapter 11 -- Managing SQL Server Permissions

3 4

Chapter 11

About This Chapter

After you have provided for user access to SQL Server 2000 and its databases through the use of Windows 2000 users and groups, and SQL Server 2000 security accounts where necessary, you must configure permissions for these users. In this chapter, you will learn how to configure database-specific permissions for users, Windows groups, and user-defined database roles. You will also learn how to use application roles. Finally, you will learn some strategies for designing security implementation scenarios combining the use of all these tools.

Before You Begin

To complete this chapter, you must have

• A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1, "Hardware Requirements," in Lesson 1 of Chapter 2.
• Microsoft Windows 2000 Server running on your computer on an NTFS partition.
• A computer with a NetBIOS name of SelfPacedCPU, configured as a domain controller in the SelfPacedSQL.MSFT domain.
• Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2).
• Created the SSEMDB database using the CreateDB.sql script (see Chapter 6).
• Completed the practice exercises in Chapter 10.