Which permission or permissions should you assign to UserC?

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.

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:
According to these references, this answer looks correct.
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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


bayou

bayou

B) Execute permission…

bayou

bayou

B) due to ownership chaining