SSIS 2008 Default Role Security Summary Table

I sometimes have trouble remembering the details of the individual default roles in SSIS 2008. These can be found in the msdb database of SQL Server 2008, and are summarised in this table, which will hopefully help a bit:

SSIS 2008 msdb Role Name

View All Packages

Export

Execute All Packages

Execute All in SQL Agent

Write Features

db_ssisadmin

Yes

Yes

Yes

Yes

Delete/Change all packages

Import Packages

db_ssisoperator

Yes

Yes

Yes

Yes

None

db_ssisltduser

Own packages only

Own packages only

Own Packages only

Delete/change own packages

Import packages

The Windows Admin role can see the execution progress of packages that are currently executing, and can also stop these packages. However, note that the package execution will stop at the point of the next task, so the package execution abort activity may not occur immediately. To add this post to Twitter, please click here.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s