لطفا منتظر باشید ...
Tested Skills and Suggested Practices
The skills that you need to successfully master the Designing a Database Security Plan objective on the Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition exam include:
Controlling object access with GRANT and REVOKE.
Practice 1: Create different user IDs.
Practice 2: Manage and modify user IDs.
Practice 3: Grant permissions to view and review the effects.
Controlling data access by using stored procedures, triggers, and user-defined functions.
Practice 1: Create a stored procedure, grant user rights on it, and look at the behavior when you try to access it with different user IDs.
Practice 2: Create triggers and control user access with the triggers.
Creating and managing application roles.
Practice 1: Create an application role.
Practice 2: Modify the application role.
