|
Home > Archive > MS SQL Server DTS > January 2006 > How to limit access to execute export DTS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to limit access to execute export DTS
|
|
| blackpit 2006-01-31, 11:24 am |
| 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?
Thank you all.
| |
| Allan Mitchell 2006-01-31, 11:24 am |
| 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/feat...cle.php/3404791
Allan
> 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?
>
> Thank you all.
>
|
|
|
|
|