Permission to view SQL jobs in SQL Server 2017

• Srinivas Sista

  SSC Enthusiast

  Points: 193

  More actions

  August 10, 2020 at 2:24 am

  #3778516

  Hi,

  I'm using SQL Server 2017, I need to give developers only to view the jobs (either it is SSIS packages which is scheduled as a job or SP scheduled as a job).

  What does edit means:- Double click the job, go to each step and see which package it is referring to and see the configuration/data sources connections for each step. I'm happy if i don't give them rights to run the job/delete the job/ and modify the job. This jobs are owened/owner of it is DBA (let us assume that proxy is not used.)

  one more thing. I know there is a role by name "SQLAgentReaderRole", i can assign but it is a combination of (All of the SQLAgentUserRole rights) + The ability to review multiserver jobs, their configurations and history. So now if i give rights to this role "SQLAgentReaderRole", and if he doesn't own this jobs still can he view the jobs and see the parameters and edit the configuration of the data source, if ssis package is scheduled as a job

  Thanks,

  SRInivas

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  August 11, 2020 at 3:10 am

  #3778817

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.