May 20, 2003 at 7:28 am
How can I grant our summer intern access to Agent Jobs in Enterprise Manager (SQL2000) without making him a member of sysadmin? That would give him too many permissions on other things. I don't see this addressed in BOL.
Thanks,
Holly Kilpatrick
Database Administrator
Mallinckrodt Baker Inc.
Phillipsburg, NJ, USA
holly.kilpatrick@tycohealthcare.com
908.859.2151 ext. 9253
May 20, 2003 at 7:30 am
The 'TargetServersrole' role in the msdb database gives access to control certain jobs. This may be what you are after
Regards
Steven
May 20, 2003 at 8:26 am
Thanks very much, I see that, and added him to that msdb role, and now the Jobs show up for him in Enterprise Manager. I appreciate your help.
When I search on Targetserversrole in BOL or MS website, or google, I hardly get anything at all. But it may do the job.
Holly
May 20, 2003 at 9:55 am
TargetServersRole is kind of secretive. It's there to support Multi-server administration and thus wasn't explicitly intended for someone to use to monitor jobs, but it has the permissions necessary to do the job (pun intended). It's one of those cases where DBAs have found a piece and made it work for them.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply