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 |
|
eastbay_user
Starting Member
3 Posts |
 Posted - 2011-06-28 : 20:41:59
|
| Hi...I have a linked server created to access an Oracle database. I NEED to know if the Oracle userid/password used to configure the linked server is encrypted. My manager is asking and I need to answer. Also, is the data passed back to SQL Server via openrowset encrypted?Thanks so much for your help!EU |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-28 : 22:15:56
|
| no and no. |
 |
|
|
eastbay_user
Starting Member
3 Posts |
Posted - 2011-06-29 : 10:27:31
|
| Thanks! So the userid/password is passed from SQL Server to Oracle as clear text? How do I encrypt it?Thanks again! |
|
|
|
|
|
|
Linked Server Security - Need Help Pls