You have an instance of SQL Server 2008 that has xp_cmdshell enabled. You need to
design a stored procedure that meets the following requirements: ·Allows authorized users

to retrieve lists of files ·Minimizes permissions assigned to objects ·Minimizes security risks
What should you include in the design?

A.
Grant users permission to execute sp_configure.

B.
Create a procedure that uses EXECUTE AS OWNER. Call xp_cmdshell in the
procedure. Grant users permission to execute the procedure.

C.
Grant users permission to execute xp_cmdshell.

D.
Create a procedure that uses EXECUTE AS CALLER. Call xp_cmdshell in the
procedure. Grant users permission to execute the procedure.