Permissions to view folder\projects\packages in SSISDB Catalog

Category: sql server ssis


Stan210 on Sat, 04 Mar 2017 12:46:26

For our SQL 2016 SSIS packages deployed in project model(SSISDB), we want give developers ability to check execution reports as well as view the projects and packages in the projects.

In sql 2016, we have ssis_logreader  database role. This role gives the ability to check execution reports without being a sysadmin or ssis admin. however, they can only check this on the root level - i.e right click on the SSISDB and reports.

What I am looking for is having the ability to view all the foldes, projects and packages mentioned in SSISDB database.

is this possible in SSIS 2016.

Hope it Helps!!


philfactor on Sat, 04 Mar 2017 13:56:19

Have you reviewed the permission section of this document (scroll down about half way)?

SSIS Catalog

Hope that helps,

Stan210 on Sun, 05 Mar 2017 13:05:16

thank you that helped...