Re: xp_cmdshell

From: Noorali Issani (naissani_at_softhome.net)
Date: 03/31/04 

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

Relevant Pages

  • Re: SQL Server Agent Proxy Account / XP_CMDSHELL
    ... The proxy account is unrelated to SQL Server object permissions. ... must have xp_cmdshell execute permissions when xp_cmdshell executed ... execute permissions on xp_cmdshell. ...
    (microsoft.public.sqlserver.security)
  • Re: Cscript from a SQL Stored Procedure?
    ... You may want to check the proxy account. ... >that uses SQL SERVER 2000 as it's database. ... >Basically we are trying to add code that calls the .vbs script so that when ... >doesn't seem to execute. ...
    (microsoft.public.sqlserver.server)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • Re: SSIS - OLE DB Command - how to retrieve query results ???
    ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
    (microsoft.public.sqlserver.dts)
  • Re: 3 Simple Security SQL Statements
    ... Kalen Delaney, SQL Server MVP ... window and execute. ... Builds a list of text commands. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ...
    (microsoft.public.sqlserver.security)