Package Roles

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 Using Integration Services Roles.

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.