Granting SSIS Permissions to a Domain Account

Scenarios

Run a stored procedure to grant SSIS permissions to a specified domain account.

Prerequisites

You have connected to an RDS for SQL Server instance. For details about how to connect to an instance, see Connecting to an Instance.

Procedure

Run the following command to authorize a domain account:

EXEC master.dbo.rds_grant_ssis_to_login [login];

login: indicates the name of the domain account to be authorized.

Example

Run the following command to authorize the domain account JHA\DCADMIN:

EXEC master.dbo.rds_grant_ssis_to_login [JHA\DCADMIN];