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 |
|
RoyalSher
Yak Posting Veteran
95 Posts |
 Posted - 2004-11-10 : 07:33:12
|
| Hi All- I have a situation here; I need to give permission to one of the developers to run a DTS package in production. I am trying to simulate in testing environments. Can anybody give me some thoughts on how would I need to go about this?Thanks in advance!RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-11 : 01:26:46
|
| provide him a user password to run the dts, else create an sp, that will run the dts, give the programmer permission to execute the spor create a GUI with a button to click that will run the dts.--------------------keeping it simple... |
 |
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2004-11-12 : 05:05:06
|
| Thanks for the quick solution. Now, I have something else to do with the same subject. Here it goes,I had an argument with my coworker on granting privileges to a developer on a production box, to build a DTS package. Well, my question was that can a developer having a NT login authentication, with select permissions on all the tables in the database, can he/she build a dts package successfully with no permission problems ?My answer is ‘yes’, it is possible. Any thoughts on this, from anybody in the forum?Thanks in advance!RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
|
DTS package permissions