You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The DB1 database 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; 06 CREATE TABLE Service.Table ( 07 Id int PRIMARY KEY CLUSTERED, 08 Name varchar(100); 09 ); 11 ... 12 GOThe 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. What action should you do perform?()
- A、Between lines 01 and 02, you should insert the WITH EXECUTE AS 'dbo' clause.
- B、Between lines 01 and 02, you should insert the EXECUTE AS USER = 'dbo' statement.
- C、You should give the user the ALTER permission on the Service schema
- D、You should give the CREATE TABLE permission and permit the user to drop the Service.Table table.
![](/editor/images/201705/qrcode_for_gh_573e2a458573_258.jpg)
微信扫一扫手机做题