You administer a Microsoft SQL Server 2012 database.
The database has a table named Customers owned by UserA and another table named Orders owned by
UserB.
You also have a stored procedure named GetCustomerOrderInfo owned by UserB.
GetCustomerOrderInfo selects data from both tables.
You create a new user named UserC. You need to ensure that UserC can call the GetCustomerOrderInfo
stored procedure.
You also need to assign only the minimum required permissions to UserC.
Which permission or permissions should you assign to UserC? Choose all that apply.
A.
The Select permission on Customers
B.
The Execute permission on GetCustomerOrderInfo
C.
The Take Ownership permission on Customers
D.
The Control permission on GetCustomerOrderInfo
E.
The Take Ownership permission on Orders
F.
The Select permission on Orders
Explanation:
The question seems to be missing something. Or the original answer is incorrect. I’ve changed it to what I
believe to be the correct answer. The original answer included “The Select permission on Orders.”, butdue to
ownership chaining, you would only need to give Execute permissions to UserC to access the Orders table
since UserB is the owner.
(BF) – need to test this
Reference:
http://msdn.microsoft.com/en-us/library/ms188676.aspx
http://stackoverflow.com/questions/2212044/sql-server-how-to-permission-schemas
http://sqlservercentral.com/blogs/steve_jones/2012/03/14/ownership-chains-in-sql-server