RE: xp_cmdshell

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 09/28/04

  • Next message: Kevin McDonnell [MSFT]: "RE: Customizing Security" 
    Date: Tue, 28 Sep 2004 21:28:42 GMT

    By default only SQL Admin have access to xp_cmdshell.
    Check the properties of SQLAgent.
     Under Non-SysAdmin Job step Proxy Account.
    This needs to be enabled with a Proxy Account first, then you'll need to
    grant access to execute
    xp_cmdshell

    sp_helprotect xp_cmdshell
    Will return a list of users granted permission.
      
    Thanks,

    Kevin McDonnell
    Microsoft Corporation

    This posting is provided AS IS with no warranties, and confers no rights.

  • Next message: Kevin McDonnell [MSFT]: "RE: Customizing Security"