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:
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
A, B ok, add to that F? no?
You dont have to give select permission to the Orders table because of ownership chain.
A and B.
A and B because of CHAINING OWNERSHIP.
UserB owns the SP and Orders table so granting EXECUTE permission on the sp Will systematicaly give select permission on Orders