Microsoft
98-364 · Question #48
98-364 Question #48: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #48. The question stem and answer options stay visible for context.
Question
You have developed a stored procedure named usp_GetEmp that accepts an employee number as a parameter and retrieves the details about the employee from the CurrentEmp table of a database named Employees. You have tested it, and it works exactly as you expected. Later, another employee tries to use the stored procedure and receives the following error: "The SELECT permission was denied on the object 'CurrentEmp', database 'Employees.schema 'dbo' ". What should you do to resolve the problem?
Options
- AModify usp_GetEmp to include the With Execute As Owner clause.
- BModify usp_GetEmp to include the With Execute As Caller clause.
- CGrant the employee the SELECT permission on the CurrentEmp table.
- DGrant the employee the SELECT permission on the Employees database.
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.