Browse All Principals Dialog Box
Applies To: SQL Server 2016 Preview
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.
What do you want to do?
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.
- Selection column
Select to add the principal to the Logins or roles list on the Permissions page of the parent dialog box.
- Icon column
An icon that corresponds to the Type of the principal.
The name of the principal.
The type of the principal. The common types are: