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.