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 |
|
Hippi
Yak Posting Veteran
63 Posts |
 Posted - 2005-03-22 : 14:28:36
|
| Hey guys,Does anybody know what is the permission to run DTS packages? and How can I control them. I ask this question since with sa or other admin users, it is OK, but with other users, it fails.Thanks a bunch. |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-22 : 15:27:18
|
| Anyone with access to the database the DTS package will be run against should be able to execute the DTS and be restricted only by the permissions granted to that database.Check your books online and lookup DTS security. The restrictions change when scheduling DTS jobs. |
 |
|
|
|
|
|
DTS packages permission