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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2004-07-23 : 06:20:48
|
| Hi, so this is the dts forum. I've posted my question on the admin forum.anyways, can someone suggest how to restrict the data import/export on an authorized user only? Also, is it possible to only allow dts between specific servers? like server1 will allow dts to server2 but not to server3.thanks in advance |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-25 : 13:40:02
|
| ??? If you have your user permissions set up correctly in the first place, both of your questions would be taken care of. What problem are you having that would cause you to ask this? Basically, whatever user is logged in only has permissions to do what his combined SQL Server/NT permissions let him do.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-07-26 : 01:50:11
|
| Sorry, my questions seem to be confusing. Let me rephrase. If a user has only select rights on a particular table can he use dts to export the data? I want to restrict the users wherein only the "authorized" users can use the dts wizard. |
|
|
|
|
|
|
DTS import/export restriction