开发者

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

开发者 https://www.devze.com 2023-03-09 19:08 出处:网络
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 beca

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

精彩评论

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