Post reply

View access to only 1 Job

  • December 15, 2022 at 9:44 am

    #4125943

    I want a user to be able to ONLY view only 1 specific job only. How can this be done?

  • December 15, 2022 at 10:56 am

    #4125965

    The simplest approach would be to make the user the owner of the job and add them to the SQLAgentUserRole. Of course this will allow them to create, modify and delete their own jobs.

    If you really just want the user to be able to view one job I suspect it will be a rather complicated mixture of explicity granting permissions to SPs and row-level security. Good luck!

    • This reply was modified 1 year, 11 months ago by  Ken McKelvey.

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

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