Sql-server – SSIS permissions for specific databases

permissionssql serverssis

I'm quite new to SSIS.

Is it a straightforward to grant SSIS permissions in the AD environment so that that a user can only create/manage/run ETL tasks on specific databases/Analysis Services projects on a SQL Server that contains multiple databases?

I.e. So a user can't extract/load data from/into a database/Analysis services project that they shouldn't etc.

Database version is SQL Server 2012.


Best Answer

If you intend to run the SSIS jobs from the SQL Agent, then they will execute as the user the agent runs as. That's usually the same as the account the instance runs as, which has rights to everything.