Re: xp_cmdshell
From: Noorali Issani (naissani_at_softhome.net)
Date: 03/31/04
- Next message: Noorali Issani: "sp_droprole"
- Previous message: Victor Kozel: "Re: Query tuning"
- In reply to: Hari: "Re: xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 15:53:18 +0500
I have created on role and I want to give permission to that role to only
execute xp_cmdshell not else..
Can you give me exact query.
thanks
NOOR
"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:uMC6pxvFEHA.2208@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> When xp_cmdshell is invoked by a user who is a member of the sysadmin
fixed
> server role, xp_cmdshell will be executed under the security context in
> which the SQL Server service is running. When the user is not a member of
> the sysadmin group, xp_cmdshell will impersonate the SQL Server Agent
proxy
> account, which is specified using xp_sqlagent_proxy_account. If the proxy
> account is not available, xp_cmdshell will fail.
>
> 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
> "Noorali Issani" <naissani@softhome.net> wrote in message
> news:uvXz#IvFEHA.4008@TK2MSFTNGP10.phx.gbl...
> > I have a user and I want to to give persmission of that user to execute
> only
> > this XP_CMDSHELL procedure nothing else. Any idea ?
> >
> > Thanks
> > NOOR
> >
> >
> >
> >
> >
> >
> >
>
>
- Next message: Noorali Issani: "sp_droprole"
- Previous message: Victor Kozel: "Re: Query tuning"
- In reply to: Hari: "Re: xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
