Hello everyone.

I want to provide the db_reader database role to some users. The problem is
that, on the same time, I don't want them to be able to export data (e.g. not
able to create and execute DTS Packages or run the DTS Wizard).

Is that possible?

Hello blackpit,

You would not be able to stop somebody creating a DTS package. DTS is COM
and if somebody has the dlls then they are up and running. DTS does not
require SQL Server for Storage either as the packages can be stored as Structured
Storgae Files.

Running a package that is stored in "Local Packages" or saving a package
to "Local Packages" is different and you can curtail this

http://www.databasejournal.com/features/mssql/article.php/3404791

Allan



[quoted text, click to view]