One Way to Script SSIS Catalog Permissions

This post is part of a series about SSIS Catalog Security. The other posts in this series are:

I recently shared a post about the latest version of SSIS Catalog Browser, which plays nice(r) with SSIS Catalog security. My friend Bob shared that he has a lot of SSIS packages deployed in his enterprise. When we communicated about the SSIS Catalog Browser version, he lamented he also has a lot of SSIS Catalog Folders. Using the method I described in the post titled One Way to Set SSIS Catalog Security¬†would be… cumbersome.

Challenge accepted.

My suggestion is to create a database role – something I describe in my post titled One Way to Create an SSIS Catalog Read-Only Database Role – and then use that role in the following, cursor-y T-SQL script to assign read and read objects permissions to all SSIS Catalog Folders in an SSIS Catalog.

As always, I welcome your feedback, suggestions, thoughts, and concerns.

:{>

 

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS guy, and farmer. I was cloud before cloud was cool. :{>

One thought on “One Way to Script SSIS Catalog Permissions

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.