create/test SSIS packages

Question

Post reply

create/test SSIS packages

Krasavita

SSC-Insane

Points: 23138
More actions
November 8, 2012 at 10:56 am

#269981

Hello,
I want to give developer secuty level to create/test SSIS packages on our test enviroment,what access level I can provide it to him?
Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

jad0083 Valued Member Points: 61 More actions · Answer 1

msdb - > db_ssisltduser

Read:

http://msdn.microsoft.com/en-us/library/ms141053%28v=sql.100%29.aspx

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

You also need to give him read permission (db_datareader) on the source and write permission on the destination (dt_datawriter).

If the user needs to use the TRUNCATE TABLE statement, he also needs db_ddladmin.

If any other objects are used outside of SQL Server (flat files, .exe files, network shares, ...), he also needs read/write/execute permission on those.

If the user is going to create SQL Server Agent jobs, he needs at least SQLAgentUserRole.

SQL Server Agent Fixed Database Roles

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP