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 xp_cmdshell.
B.
Grant users permission to execute sp_configure.
C.
Create a procedure that uses EXECUTE AS OWNER. Call xp_cmdshell in the procedure. Grant users permission to execute the procedure.
D.
Create a procedure that uses EXECUTE AS CALLER. Call xp_cmdshell in the procedure. Grant users permission to execute the procedure.