Giving access to a couple of users to run specific SQL jobs

• Feivel

  SSCertifiable

  Points: 7524

  More actions

  April 29, 2020 at 8:56 pm

  #3747472

  I have a requirement to grant a couple of users access to run specific SQL jobs that runs SSIS packages. Is there a way to grant them access in some way to address the issue of not granting them too much access.

  • This topic was modified 3 years, 11 months ago by  Feivel.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734418

  More actions

  April 30, 2020 at 4:09 pm

  #3747733

  https://www.sqlservercentral.com/forums/topic/how-to-grant-permissions-to-run-a-specific-sql-agent-job

  Short answer, create aw proc to run  the job, give users permission to the proc. The proc needs EXECUTE AS