RE: xp_cmdshell

From: Hari Prasad (HariPrasad_at_discussions.microsoft.com)
Date: 09/29/04 

Date: Tue, 28 Sep 2004 18:07:01 -0700

Hi,

Add on to Kevin to create a proxy account:-

How to set the proxy account:

1. Open enterprise manager and select management options
2. Right click abouve the sql Agent and select properties
3. Select the "job system" option
4. Set the "Non sysadmin job step proxy account
5. There you have give the valid OS level user with previlage.

Thanks
Hari
MCDBA

"Kevin McDonnell [MSFT]" wrote:

> 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.
>
>
>
>