Using Integration Services Fixed Database Level Roles
Integration Services enables you to control access to SSIS packages by providing three fixed database-level roles: db_dtsadmin, db_dtsltduser, and db_dtsoperator. These are available in msdb database and can be applied to only the packages that are saved to the msdb database in SQL Server. The packages stored in MSDB storage area in Integration Services are saved in sysdtspackages90 table of the msdb database. The sysdtspackages90 table defines the access permissions for the packages in the readrole, writerole, and ownersid columns of the table.
Fixed Database Level Roles and Their Permissions
When you use the ServerStorage option for the ProtectionLevel property, the access to the packages ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
