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.