TABLE 1 Default Role Privileges
Member of Role Read Operations Write Operations
Enumerate Own Packages Enumerate All Packages View Own Packages View All Packages Execute Own Packages Execute All Packages Export Own Packages Export All Packages Execute Own Packages in Agent Execute All Packages in Agent Import Packages Delete Own Packages Delete All Packages Edit Own Packages Edit All Packages Change Own Package Roles Change All Package Roles
db_dtsadmin X X X X X X X X X X X X X X X X X
db_dtsltduser X X X - X - X - X - X X - X - X -
db_dtsoperator N/A X N/A X N/A X N/A X N/A X - N/A - N/A - N/A -
Readrole + db_dtsoperator N/A X N/A X N/A X N/A X N/A X - N/A - N/A - N/A -
Readrole + db_dtsltduser X X X - X - X - X - X X - X - X -
Readrole - - - - - - - - - - - - - - - - -
Writerole + db_dtsoperator X X X - X - X - X - N/A X - X - X -
Writerole + db_dtsltduser X X X - X - X - X - X X - X - X -
Writerole - - - - - - - - - - - - - - - - -