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 |
|
RichardSteele
Posting Yak Master
160 Posts |
 Posted - 2007-10-21 : 19:40:28
|
| We have a Foxpro database on our local machine and a shared sql server database on our remote machine. We have created a remove view that updates or inserts data into the sql server db using the local foxpro data. What is the recommended way to secure these updates or inserts? We're worried that since our data is not encrypted, it is a security risk. Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-21 : 20:41:10
|
| Set proper permission on sql tables for sql login that used to coonec to sql from foxpro. |
 |
|
|
RichardSteele
Posting Yak Master
160 Posts |
Posted - 2007-10-21 : 20:47:00
|
| I'm more concerned with the data flowing between the local and remote databases. It's not encrypted and thus prone to sniffing. I'm not sure how to encrypt this data. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-21 : 21:07:46
|
| If you installed sql client on your local machine, you can try encrypt that by choosing encrypt sql protocol. |
|
|
|
|
|
|
Remote View Security