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.
其他部门的用户要求我授予他们在SQL Server代理中执行Schedule Jobs / SSIS。目前，他们在ManagmentStudio中看不到SQL Server Agent树。我想，这是因为他们没有权利执行它们。
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 roles in my server, I could only see the following server roles
所以，我想知道我应该给他们哪个服务器角色。我只想给他们最低限度的特权。当我检查服务器中的现有角色时，我只能看到以下服务器角色
- bulkadmin
- bulkadmin
- dbcreator
- dbcreator
- diskadmin
- diskadmin
- processadmin
- processadmin
- public
- 上市
- securityadmin
- 是securityadmin
- serveradmin
- 的ServerAdmin
- setupadmin
- setupadmin
- sysadmin
- 系统管理员
Please advise me.
请建议我。
1 个解决方案
#1
19
It isn't a server role.
它不是服务器角色。
It is one of the "SQL Server Agent Fixed Database Roles" in msdb
它是msdb中的“SQL Server代理固定数据库角色”之一
请参阅MSDN上的“如何：配置用户以创建和管理SQL Server代理作业（SQL Server Management Studio）”
#1
19
It isn't a server role.
它不是服务器角色。
It is one of the "SQL Server Agent Fixed Database Roles" in msdb
它是msdb中的“SQL Server代理固定数据库角色”之一
请参阅MSDN上的“如何：配置用户以创建和管理SQL Server代理作业（SQL Server Management Studio）”