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?

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?

Accepted Answer

A. Modify usp_GetEmp to include the With Execute As Owner clause.

Answer

B. Modify usp_GetEmp to include the With Execute As Caller clause.

Answer

C. Grant the employee the SELECT permission on the CurrentEmp table.

Answer

D. Grant the employee the SELECT permission on the Employees database.

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…

Question

Options

How the community answered

Community Discussion