SQL Server 2008 Job execution/creation features

  • Looking for a method to creating jobs as System Admin but allowing operators to view and execute not modify/delete. The operators will have access to MS Management Studio. I also want to know if any recommendations exist to securing objects seen via MS Management Studio (2008)

  • You could add the operators to the fixed database role SQLAgentOperatorRole in msdb, which can view and execute jobs it doesn't own. Review the other permissions the role has in BOL to decide if it's right for your situation.

    Greg

  • Good place to start.

    Thanks

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

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