运行SQL JOB的权限 - SSIS [英] Permissions to run SQL JOB - SSIS

问题描述

HI

我创建了一个在sql作业中运行的SSIS包....

I created a SSIS package which run in a sql job....

我创建了一个代理和凭证使用Windows帐户..

I created a proxy and credential which work with a windows account..

在SQLSERVER 2012中，sql作业的权限运行没有问题？

What are the permissions to the sql job runs without problem in SQLSERVER 2012?

Windows accout具有权限到网络目录。

The windows accout has permissions to the network directories.

连接管理器有帐户可以连接到数据库

The connection managers have account which can connect to the databases

推荐答案

在SQLSERVER 2012中，sql作业的权限有没有问题？

What are the permissions to the sql job runs without problem in SQLSERVER 2012?

以下是sp_start_job文档（https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-start-job-transact-sql）的摘录摘录：

Below is the excerpt excerpt from the sp_start_job documentation (https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-start-job-transact-sql):

<摘录>

<Excerpt>

默认情况下，sysadmin固定服务器角色的成员可以执行此存储过程。必须在msdb数据库中为其他用户授予以下SQL Server代理固定数据库角色之一：

By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted one of the following SQL Server Agent fixed database roles in the msdb database:

• SQLAgentUserRole
• SQLAgentReaderRole
• SQLAgentOperatorRole

有关这些角色的权限的详细信息，请参阅SQL Server代理固定数据库角色。

For details about the permissions of these roles, see SQL Server Agent Fixed Database Roles.

这篇关于运行SQL JOB的权限 - SSIS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！