Microsoft
70-432 · Question #75
70-432 Question #75: Real Exam Question with Answer & Explanation
The correct answer is C. You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You have to make sure that a user can successfully execute Procedure1 complying with the company rules. Which action should you perform to achieve this goal?
Options
- AYou should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL
- BYou should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL
- CYou should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
- DYou should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately
Community Discussion
No community discussion yet for this question.