Re: User that can run jobs

From: Evgeny Kleiman (ekleiman_at_mekorot.co.il)
Date: 06/28/05 

Date: Tue, 28 Jun 2005 13:37:11 +0200

Thank very much to all who answered me. Uri, I am not DBA, so I need in more
detail instructions (unfortunately,
our DBA also don't know this theme): what operations should DBA execute
allowing to a user(that is not a member of the sysadmin fixed server role)
to run job
Thank you
Evgeny

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:eHkqtL8eFHA.1600@tk2msftngp13.phx.gbl...
> Jenya
> Ih the user is not a member of sysadmin server role he/she can execute
jobs
> that he/she owns
> BOL says
> When the user ,
> sp_start_job will impersonate the SQL Server Agent proxy account, which is
> specified using xp_sqlagent_proxy_account. If the proxy account is not
> available, sp_start_job will fail.
>
>
>
>
>
>
> "Evgeny Kleiman" <ekleiman@mekorot.co.il> wrote in message
> news:uZ8B4F8eFHA.2728@TK2MSFTNGP10.phx.gbl...
> > Hello
> >
> > I need to define a user of SQL Server 2000 that could run jobs. At
> present
> > time I succeeded only in the case that the user has rights of system
> > administrator (in Enterprise Manager in Logins I click right on the user
> and
> > in Properties/Server Roles I check box System administrator). But it’s
too
> > strong for my aim. Is there another solution?
> >
> > Thank you
> >
> > Evgeny
> >
> >
>
>

Relevant Pages

  • Re: Can I....
    ... Member: http://dts-l.org ... dba wrote: ... Have a bunch of files with a .txt extension. ...
    (microsoft.public.windowsxp.general)
  • Security for administators of Oracle databases
    ... more than one DBA working on the server/database. ... account and login with a generic DBA account. ... you are a member of the DBA group you can always connect / as sysdba. ...
    (comp.databases.oracle.server)