2

Experts, I have two databases, one is SSISDB, other is user database. Both of them are a part of Always on availability group. I need to give one user a permission to be able to deploy a package. How should I go about doing this. He already has a login and has a data reader access to both the databases. We are talking about SQL server 2016 EE here. Thanks.

1

You have 2 options.

  1. Make the user a member of ssis_admin role which of course give more privilege than you intend to.

This role provides full administrative access to the SSIS Catalog database.

  1. You can give permission at folder level under integration services catalogs. Here you have a better control, but you have to do this for each folder. Details explained here: SSIS Catalog
  • I am glad that it worked for you. If answer satisfied your question please mark as accepted so other users do not think you are still waiting for an accepted answer plus others can be benefited from the same question. – SqlWorldWide Sep 28 '17 at 14:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.