SQL2000 相当于 SQLAgentReaderRole
有不少开发人员询问我某些 SQL 作业是否运行，我想授予他们自行检查的权限，而不授予他们 sysadmin 权限。 我知道在SQL 2005中，您可以授予他们SQLAgentReaderRole，但我正在SQL 2000中寻找解决方案。
I have quite a few developers asking me if certain SQL jobs ran, and I would like to give them access to check it on their own without giving them sysadmin rights. I know that in SQL 2005, you can grant them the SQLAgentReaderRole, but I am looking for a solution in SQL 2000.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
看来我们这些仍在使用 2000 的人还有一些希望 -
“为了在 SQL Server 2000 中完成此操作，DBA 必须将用户添加到 MSDB 数据库中的 TargetServersRole 角色。在 SQL Server 2000 上的 Service Pack 3 之前，用户必须是添加到 sysadmin 组，以便有机会查看 sysadmin 组拥有的作业。”
引用自 http://www.sql-server-performance.com/faq/sqlagent_scheduled_jobs_p1 .aspx 通过 http: //social.msdn.microsoft.com/Forums/en/sqlsmoanddmo/thread/8a05fe47-50c7-4b95-b631-8f7d69d31dae
Looks like there's some hope for those of us still working with 2000 -
"In order to accomplish this in SQL Server 2000 the DBA must add the user to TargetServersRole role in MSDB database. Prior to Service Pack 3 on SQL Server 2000 the user must be added to the sysadmin group in order to get a chance to view the jobs that are owned by sysadmin group."
Quoted from http://www.sql-server-performance.com/faq/sqlagent_scheduled_jobs_p1.aspx via http://social.msdn.microsoft.com/Forums/en/sqlsmoanddmo/thread/8a05fe47-50c7-4b95-b631-8f7d69d31dae
很确定没有一个开箱即用的。 这个线程似乎相当不错......中途他们讨论创建一个角色，然后进一步锁定它。 此外，您还可以创建一个小程序（甚至？）来通过电子邮件发送作业结果作为摘要，或者向每个作业添加完成事件以通过电子邮件发送电子邮件组。
http://sqlforums.windowsitpro。 com/web/forum/messageview.aspx?catid=60&threadid=43021&enterthread=y
Pretty sure there isn't one out of the box. This thread seems to be pretty decent...halfway down they discuss creating a role and then locking that down further. Also you could just create a mini-program (sp even?) to email the results of the job as a summary, or add to each job an on completion event to email an email group.
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=43021&enterthread=y