Re: User that can run jobs

From: Uri Dimant (urid_at_iscar.co.il)
Date: 06/28/05

  • Next message: Jens Süßmeyer: "Re: User that can run jobs" 
    Date: Tue, 28 Jun 2005 12:22:39 +0300

    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 is not a member of the sysadmin fixed server role,
    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
    >
    >

  • Next message: Jens Süßmeyer: "Re: User that can run jobs"

    Relevant Pages

    • Re: How to Grant permissions to Database
      ... Is the user ammember of sysadmin server role and db_owner fixed database ... If he/she is not a member of the sysadmin fixed server role but is a member ...
      (microsoft.public.sqlserver.security)
    • Executing fn_trace_getinfo as non system administrator
      ... is not a member of system administrator fixed server role? ... I need to create a user with restricted privileges but still is able to get ...
      (microsoft.public.sqlserver.security)
    • Re: For Andrea...Install MSDE w/ MSDE Depl.Toolkit. cont.
      ... he's not a member of either. ... > MSDE database when it is installed locally? ... sure member of sysadmins server role.. ... Andrea Montanari ...
      (microsoft.public.sqlserver.msde)
    • how can a user who is in a role assign his role to another user?
      ... 'ABC01' is not a member of the sysadmin fixed server role or the db_owner fixed database role or the db_securityadmin fixed database role, can he assign his role to another user? ...
      (microsoft.public.sqlserver.security)
    • RE: adding users to db fixed roles
      ... >Only members of the sysadmin fixed server role and the ... Role owners can execute sp_addrolemember ... to add a member to ... >database role can add users to any user-defined role. ...
      (microsoft.public.sqlserver.security)