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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-19 : 11:26:53
|
Silvia writes "Hi all,
this is my problem . I need to transfer data between 2 sql serverl (2000) and I'd like to use linked server system but I've goto some dubts regarding security. Imagine SQL1 (my server) and SQL2 foreign server that need to put data in a table on SQL1.
To make it possible SQL2 must have a login and pwd to access that table in a db. In this case I saw that is possible for a remote user of SQL2 to open with enterprise manager a console on my SQl1 and from there browsing dbs, dts, access in master database.... so it's a problem for the security on my SQL1 (may be see procedure, organizations, access to master db...changing somethings). How can I avoid this situation? I'd like to permit to the remote user just to put (insert,update,delete ) datas just in one table and have access to that table only without see my SQL structure ..... Is the linked server the best way to interchange datas ?
Thank you for all your help.
Silvia" |
|
|
|
|
|
Transfering data between SQL Server