[SQL Server] Créer un compte sql avec les droits de déploiement et exécutions du package SSIS
CREATE ROLE ssis_deployer;
GRANT EXECUTE ON OBJECT::[SSISDB].[catalog].[deploy_project] TO ssis_deployer;
GRANT ALTER ON OBJECT::[SSISDB].[catalog].[folders] TO ssis_deployer;
GRANT CONNECT TO ssis_deployer;
-- Ajouter l'utilisateur au rôle
ALTER ROLE ssis_deployer ADD MEMBER [VotreUtilisateur];
CREATE ROLE ssis_executor;
GRANT EXECUTE ON OBJECT::[SSISDB].[catalog].[create_execution] TO ssis_executor;
GRANT EXECUTE ON OBJECT::[SSISDB].[catalog].[start_execution] TO ssis_executor;
GRANT EXECUTE ON OBJECT::[SSISDB].[catalog].[set_execution_parameter_value] TO ssis_executor;
GRANT READ ON OBJECT::[SSISDB].[catalog].[folders] TO ssis_executor;
GRANT EXECUTE ON OBJECT::[SSISDB].[catalog].[projects] TO ssis_executor;