Export (0) Print
Expand All

Package Roles Dialog Box UI Reference

Use the Package Roles dialog box, available in SQL Server Management Studio, to specify the database-level roles that have read access to the package and the database-level roles that have write access to the package. Database-level roles apply only to packages that are stored in the SQL Server msdb database.

To learn more about the Integration Services database-level roles and their permissions, see Integration Services Roles (SSIS Service).

The roles listed in the dialog box are the current database roles of the msdb system database. If no roles are selected, the default Integration Services roles apply. By default, the reader role includes db_ssisadmin, db_ssisoperator, and the user who created the package. A user who is a member of one of these roles or created the packages can enumerate, view, export, and run packages. By default, the writer role includes db_ssisadmin and the user who created the package. A user who is a member of this role and the user who created the packages can import, delete, and change packages.

The ownersid column in the sysssispackages table lists the unique security identifier of the user who created the package.

Package Name

Specify the name of the package.

Reader Role

Select a role in the list.

Writer Role

Select a role in the list

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft