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)
 Security DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-12-04 : 15:10:37
Gert writes "Why can every logged in user read my DTS packages, modify and execute them.
So others can use my DB connections with in the package.

This is not possible with Jobs, which can only be seen by the owner or the sysadmin.

Windows 2000 SP2
SQL 2000
NT 4 Domain

Yours
Gert"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2001-12-04 : 16:47:57
take away their rights to msdb and they will not be able to see any packages.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -