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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-