You are a database developer. You plan to design a database solution by using SQL Server 2008.
There are two schemas named Sales and Marketing. You are the owner of the Sales schema and the Marketing schema is owned by a user named MarketingUser.
Users of the Marketing schema do not have permissions to access the Sales schema. You have permissions to create objects in all schemas in the database.
The Sales schema has a table named Customers.
You plan to create a storedprocedure in the Marketing schema for the marketing team. The stored procedure will select data from the Customers table and will be owned by MarketingUser.
You need to ensure that the marketing team is able to execute the stored procedure.
What should you do?
A.
Create the procedure by using the EXECUTE AS SELF option.
B.
Create the procedure by using the EXECUTE AS CALLER option.
C.
Create the procedure by using the EXECUTE AS OWNER option.
D.
Create the procedure by using the EXECUTE AS USER=MarketingUser option.