Hello, in my enterprise, we have allowed two users to built and deploy their own packages on our Sql Server 2008 R2 giving them only the db_ssisltduser role. This has created no problem until some days ago, when we discovered a user needs to overwrite the packages deployed by the other one. I dig around and i discovered this could be done changing the Write Role for the packages, adding the db_ssisltduser or another custom role, however this has to be done for every package manually and could be a problem. I also discovered that playing with the settings in the database msdb i could change the default role assignment for every package (if i correctly understood), however i cannot procede this way because i do not want that users to edit the packages created by the db_ssisadmin users. Is there any way to change the default package roles for a specified set of packages, for example the one deployed in a specific folder in Intergration Services/MSDB ? Do you have any other solution? Thanks a lot! Luigi

A nice to have, but the SSIS/SQL Server security does not have this provided, the model is not to operate at a folder level. Arthur My Blog