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.
To complete this chapter, you must have