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 named Task_Admin can update all task information in 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.
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.
B.
Add the Task_Admin role to the db_accessadmin fixed database role.
C.
Grant Update permissions on the Tasks table to the Task_Admin role.
D.
Grant Update permissions on the Tasks table to the User1 role for each column except
the CloseDate and EstimatedTime columns.