SSIS Permissions to prevent only deployment of project
ssisadmin gets all the privileges in ssis. There is no option to use custom roles in ssisdb as ssisadmin is hard coded in the ssis internal procedures. If we have to give users all the privileges (like create folder, create environments) but deny only deploying new projects, there is no way to do it. This leads to a lot of dependency on ssis administrator because he has to handle everything for the users..
Can we have
- A new role for allowing everything of ssis_admin but not the deployment?
- Using custom roles, so that we can control access to various artifacts of ssis individually.