Undocumented Role in msdb: TargetServersRole

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Undocumented Role in msdb: TargetServersRole

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-19 : 11:18:21

Michelle writes "I am looking for documentation on this role in msdb. It appears to give users the necessary permissions to manage jobs (start, stop, add, delete, edit). Assigning a user account to this role vs. granting a user account the 'same' permissions that this role seems to have does not seem to yield the same results. Apparent permissions are:

EXEC:
sp_downloaded_row_limiter
sp_help_jobschedule
sp_help_jobstep
sp_sqlagent_check_msx_version
sp_sqlagent_probe_msx
sp_sqlagent_refresh_job

SELECT, UPDATE, DELETE from:
sysdownloadlist

SELECT, UPDATE from:
sysjobs
sysjobservers
systargetservers

This role appears in all of our 7 and 2K boxes. It was definitely created during the install - check it out!

Michelle"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources