Re: Giving access to manage sql jobs

From: Uri Dimant (urid_at_iscar.co.il)
Date: 03/27/05

  • Next message: Mike: "User account for web applications (to avoid sql-injection)" 
    Date: Sun, 27 Mar 2005 12:03:42 +0200

    Jake
    Do you want the user to be able to modify only his/her jobs or all people?

    He/She mus be a member of sysadmin server role otherwise you are going to
    create a proxy account for the user. Please refer for more details to the
    BOL

    "Jake Smythe" <rondican@hotmail.com> wrote in message
    news:ennyTBZMFHA.164@TK2MSFTNGP12.phx.gbl...
    > Hello,
    >
    > I have a someone that I would like to be able to create/modify sql
    jobs.
    > What permissions, and how, can I give them permissions without making them
    > an sa? Is there is a good reference out there that describes how to set
    > permissions like this? Thanks in advance.
    >
    > Jake
    >
    >

  • Next message: Mike: "User account for web applications (to avoid sql-injection)"

    Relevant Pages

    • Re: GK - Granting on all objects but not on JOBs ?????
      ... You have to be member of SYSADMIN server role or member of DB_OWNER role ... in MSDB database. ... procedures etc) and NOT on JOBs? ...
      (microsoft.public.sqlserver.security)
    • RE: Collisions between converter(?) and TSO?
      ... Yes, I am modifying the member ... I've got 20 or so jobs that exercise ... Collisions between converter(?) and TSO? ... Your OP said "Modify a JCL INCLUDE used by the job." ...
      (bit.listserv.ibm-main)
    • Re: PDS automatic compress
      ... I must use disp=shr to avoid compress of the data set as soon as it ... > parameter in the JCL that adds the new member? ... > John Lock wrote: ... >> I want to create a new member in a PDS from each of dozens of jobs. ...
      (bit.listserv.ibm-main)
    • Re: Bob Crow is a Complete and Utter B*ST*RD!
      ... RMT member, are you? ... I wish I was a member of a union that looked after its members' ... jobs and pensions rather than one whose general secretary gave my ...
      (uk.transport.london)
    • RE: Collisions between converter(?) and TSO?
      ... submit the JCL 70 times while referencing a different INCLUDE member ... the jobs include members ABC and XYZ. ... you are submitting the JCL ...
      (bit.listserv.ibm-main)