You are a database developer. You develop a task management application that connects to a SQL Server 2008 database named TaskDB.
Users log on to the application by using a SQL Server login.The application contains a module named Task that assigns tasks to users. Information about these tasks is stored in the Tasks table of the TaskDB database. The Tasks table contains multiple columns. These include the CloseDate and EstimatedTime columns.
The application must meet the following security requirements:
Users assigned to a database role named User1 can update all task information columns except the CloseDate and the EstimatedTime columns in the Tasks table.
Administrative users assigned to a database role namedTask_Admin can update all task informationin the Tasks table.
You need to design a strategy to meet the security requirements.
Which two actions should you perform? (Each correct Answer presents part of the solution. Choose two.)
A.
Add the Task_Admin role to the db_accessadmin fixed database role.
B.
Grant Update permissions on the Tasks table to the Task_Admin role.
C.
Grant Update permissions on the Tasks table to the User1 role for each column except the CloseDate and Estimated Time columns.
D.
Create an INSTEAD OF trigger on the Tasks Table. Use the Is_Member function to prevent the User1 role from updating the CloseDate and EstimatedTime columns.