Executing a job with domain credentials

  • We have a development server that all developers have sql admin rights to so they are able to run any job. Is there any way to restrict them from running one particular job on that server that hits a production share?

  • Since every developer has sys admin rights on the development DB, you cannot keep one job away from them. You could always delete that job or disable it so that they wont run it by mistake.

    -Roy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply