Here are some questions to help you determine whether you have learned enough to move on to the next chapter. If you have difficulty answering these questions, review the material in this chapter before beginning the next chapter. The answers for these questions are located in the Appendix, "Questions and Answers."
- You created a Windows 2000 security group for users of the SalesReporting database on your SQL Server 2000 installation and placed the sales managers in this group. You then granted this group access to SQL Server 2000 and the SalesReporting database. In addition, you made this group a member of the db_datawriter and db_datareader fixed database roles. Several members have complained that although they can access the data in each table and view in the database, they are only able to execute certain stored procedures, but not all. To make matters more complicated, one of the members of this group can execute all of the stored procedures without a problem. What are the likely causes of this problem?
- You need to grant certain users the ability to insert new data into a highly secure database. They also require very limited lookup rights to the data. You are concerned about security for this data. What is the most secure method you can use to allow the users to perform their task?
- You are designing a security strategy for your SQL Server 2000 installation. You are only allowing access to Windows 2000 users and groups. Is there any advantage to applying permissions to user-defined database groups rather than directly to Windows groups?