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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS permissions

Author  Topic 

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2002-01-25 : 11:20:56
How do I set permissions on a DTS package. If I create the dts package it has me as the owner and other users are denied access to editing the package.

JamesH
Posting Yak Master

149 Posts

Posted - 2002-01-25 : 15:45:30
Open the package, click on Package.Save As there you will see a owner password, user password. If your
quote:
If I create the dts package it has me as the owner and other users are denied access to editing the package.
statement is a question then I would suggest that you use the 'User' Password option. It will allow them to execute the package but not view the package definition.

Hope this helps,

JamesH.

Go to Top of Page

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2002-01-29 : 13:57:20
The users can run the package but cannot edit the package. I want to allow multiple programmers to edit the package but it will only allow the owner of the package to make and save changes to the package.

????????????????

Go to Top of Page
   

- Advertisement -