Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicole
Yak Posting Veteran
97 Posts |
 Posted - 2006-03-02 : 23:06:03
|
| Is there any access control available for the DTS package? I want to create an a/c that can create/modify but cannot delete DTS. Is there any way I can do that? |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2006-03-03 : 01:40:47
|
| I dont think thr is any access control(as tat for db's) available.But when saving DTS packages to SQL Server, you will get an option to specify a user password and an owner password. -Setting a user password ensures that only those people who know the password can execute the package. -Once the owner password is set, one cannot modify the package without knowing this password.Thank you |
 |
|
|
nicole
Yak Posting Veteran
97 Posts |
Posted - 2006-03-03 : 03:54:56
|
Thanks for your info  My situation is: all databases dev, uat, and production are on the same server. However, we don't want the developers to create/modify/delete DTS of the production database, that's the problem I have to solve  |
|
|
|
|
|
|
DTS Access Control