70-457 · Question #119
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…
The correct answer is A. The Select permission on Customers B. The Execute permission on GetCustomerOrderInfo. 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.", but due to ownership chaining, you would only need to give Execute…
Question
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.
Options
- AThe Select permission on Customers
- BThe Execute permission on GetCustomerOrderInfo
- CThe Take Ownership permission on Customers
- DThe Control permission on GetCustomerOrderInfo
- EThe Take Ownership permission on Orders
- FThe Select permission on Orders
How the community answered
(34 responses)- A79% (27)
- C3% (1)
- D3% (1)
- E6% (2)
- F9% (3)
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.", but due to ownership chaining, you would only need to give Execute permissions to UserC to access the Orders table since UserB is the owner.
Topics
Community Discussion
No community discussion yet for this question.