Package Roles

Updated: 14 April 2006

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 SQL Server 2005 Integration Services (SSIS) database-level roles and their permissions, see 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_dtsadmin, db_dtsoperator, 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_dtsadmin 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 sysdtspackages90 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

Release History

14 April 2006

Changed content:
  • Updated default members of reader and writer roles.

Community Additions

ADD
Show: