Microsoft
70-433 · Question #202
70-433 Question #202: Real Exam Question with Answer & Explanation
The correct answer is A. Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause.. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named DB1. which contains the following stored procedure. (Line numbers are useded for reference only.) 01 CREATE PROCEDURE Sales.Procedure1 02 AS 03 IF OBJECT_ID('Service.Table') IS NOT NULL 04 DROP TABLE Service.Table; 05 06 CREATE TABLE Service.Table ( 07 Id int PRIMARY KEY CLUSTERED, 08 Name varchar(100); 09 ); 10 11 ... 12 GO The following exception is raised when a user tries to invoke Procedure1, "Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'." You should grant the user access to execute Procedure1, you must assign only the required permissions. Which action should you perform?
Options
- ABetween lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause.
- BBetween lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement.
- CYou should give the user the ALTER permission on the Service schema
- DYou should give the CREATE TABLE permission and permit the user to drop the
Community Discussion
No community discussion yet for this question.