多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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. 
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题