PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What should you do to resolve the problem?

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?