70-432 · Question #75
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…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #75. The question stem and answer options stay visible for context.
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
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.