开发者

Server Role to execute SQL Server Agent Jobs in SQL SERVER 2008

The users from other departments ask me to grant them to execute Schedule Jobs / SSIS in SQL Server Agent. At present, they cannot see SQL Server Agent tree in their ManagmentStudio. I think, it's because they don't have the rights to execute them.

So, I would like to know which server role should I give to them. I only want to give them minimum privileges. When I check the existing role开发者_高级运维s in my server, I could only see the following server roles

  1. bulkadmin
  2. dbcreator
  3. diskadmin
  4. processadmin
  5. public
  6. securityadmin
  7. serveradmin
  8. setupadmin
  9. sysadmin

Please advise me.


It isn't a server role.

It is one of the "SQL Server Agent Fixed Database Roles" in msdb

See "How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)" on MSDN

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜