Browse All Principals Dialog Box
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Use the Browse All Principals dialog box to select a database principal to change the principal’s permissions on the selected project or on all projects contained in a selected folder.
In SQL Server Management Studio, connect to the Integration Services server.
You’re connecting to the instance of the SQL Server Database Engine that hosts the SSISDB catalog.
In Object Explorer, expand the tree to display the Integration Services Catalogs node.
Expand the SSISDB node.
To change the principal’s permissions on all projects contained in a selected folder, right-click the folder and then click Properties.
To change the principal’s permissions on a selected project, expand the folder that contains the project, right-click the project, and then click Properties.
Select the Permissions page, and then click Browse.
This page displays the principals from the catalog view, sys.database_principals, of the SSISDB database.
Selecting principals adds them to the Logins or roles list on the Permissions page of the parent dialog box when you click OK and close the Browse All Principals dialog box. After adding principals to the Logins or roles list, you can change their permissions on the selected project.