Home Forums SQL Server 2008 SQL Server 2008 - General how to modify another jobs without sa? RE: how to modify another jobs without sa?

  • March 22, 2018 at 3:46 pm

    #1984363

    Jeff Moden - Thursday, March 22, 2018 3:28 PM

    tony28 - Thursday, March 22, 2018 12:28 PM

    Hello,

    is any way how to do rights for user, and he will be possible modify another than only his jobs ?
    some possible create my role than has more right than SQLAgent Operator in msdb and will be possible also update in Wizard and not with procedure ? 
    Thanks

    To be honest, I wouldn't give any user such privs.  They can get me fired with such privs.  Worse than that, they can cause great harm to the company where the company could lose customers and that could put a whole lot of people out of a job.  Any and all jobs must be reviewed by a DBA for the sake of safety of the data and safety of the server and I don't care whose data it actually belongs to.

    Hello,

    this is some kind of customer DBA, not directly any user, but we want to prevent some missunderstanding due to some change configuration on servers. So this is why I would like these kind of permission. For edit/manage jobs, because they know what they are doing, but prevent to some setting on servers, because this is my responsibility.
    I know that for example SQLaudit is possible for checking if something happens, but in 2012 and more, here cannot ,, this is not enterprise 2008 R2.

    But in generally I agree with you, in ideal world be would good, but you know... sometimes..... 🙂

    Thanks