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 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.

Options

• Package Name
  Specify the name of the package.

• Reader Role
  Select a role in the list.

• Writer Role
  Select a role in the list

See Also

Reference

Other UI Reference

Other Resources

Database-Level Roles
Security Considerations for Integration Services
Security Considerations for Databases and Database Applications

Help and Information

Getting SQL Server 2005 Assistance

Change History