【单选题】
You work in a company which is named Wiikigo Corp. The company 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. 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 th
A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.
B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
D、You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.
查看正确答案
