June 26, 2008 at 8:38 am
Once I define the new user, usually a Domain ID, they want to see the jobs in SQL Server Agent. See if they run OK, or failed. What kind of permission should be granted to browse jobs to other ID's?. Read only to MSDB database did not work. (Only SYSADMIN works, but I can not grant SYSADMIN to a developer in a Semi or Production environment. Please Help........
June 26, 2008 at 8:42 am
SQL 2005:
Use the SQLAgentUserRole and SQLAgentReaderRole to define users who want to view the jobs only.
If they want to execut the jobs, place them under SQLAgentOperatorRole
Maninder
www.dbanation.com
June 26, 2008 at 9:05 am
This is great ..... Thanks, How about in SQL Server 2000, anything similar?.
Please help.......
June 26, 2008 at 10:05 am
It's not as simple in SQL 2000. You have to grant EXECUTE permission on sp_help_job and sp_get_composite_job_info in msdb.
Greg
June 26, 2008 at 10:08 am
you can create a role in msdb in 2000 and I'd recommend that.
Be sure to include it in your DR planning as this would be needed in a rebuild.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply