Your SQL Server 2008 database contains two tables named Customer and Order inside the
Sales schema. The Sales schema is defined as follows: It has a stored procedure named
SetCustomerStatus that reads from Order and modifies Customer. It is owned by a user
named SalesUser. Another user named marketingUser wants to be able to call
SetCustomerStatus and change the status of Customer. You need to assign the least
permission necessary to MarketingUser. What should you do? (More than one answer
choice may achieve the goal. Select the BEST answer.)
A.
Perform the following tasks: Set Select on Customer. Set Update on Order.
B.
Perform the following tasks: Set Execute on SetCustomerStatus. Set Select on
Customer. Set Update on Order.
C.
Set only Execute on SetCustomerStatus.
D.
Set only Take Ownership on ustomer and Order.