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 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
Release | History |
---|---|
14 April 2006 |
|