Home » RDBMS Server » Security » Secure Data over Database Link (RDBMS 11g)
Secure Data over Database Link [message #616016] Wed, 11 June 2014 10:31 Go to next message
ajnewbs
Messages: 8
Registered: June 2014
Location: UK
Junior Member
Hi

Please can you tell me the simplest way to secure data through a database link over the internet.

RDBMS version is 11.2

Thanks.
Re: Secure Data over Database Link [message #616020 is a reply to message #616016] Wed, 11 June 2014 10:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please can you tell me the simplest way to secure data through a database link over the internet.
HTTPS
Re: Secure Data over Database Link [message #616022 is a reply to message #616016] Wed, 11 June 2014 10:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can use Oracle native network encryption (part of Entreprise Edition).
You have to configure your sqlnet.ora files in both side for this.

Re: Secure Data over Database Link [message #616023 is a reply to message #616022] Wed, 11 June 2014 10:56 Go to previous messageGo to next message
ajnewbs
Messages: 8
Registered: June 2014
Location: UK
Junior Member
Thank you for replying.

I have searched through the Oracle documentation and found a lot of information but not a lot to help me set it up a quick test - is this possible?

Do you know where I can find a simple step by step guide or even an example.



Re: Secure Data over Database Link [message #616025 is a reply to message #616023] Wed, 11 June 2014 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read Network Encryption

Re: Secure Data over Database Link [message #616087 is a reply to message #616025] Thu, 12 June 2014 04:17 Go to previous messageGo to next message
ajnewbs
Messages: 8
Registered: June 2014
Location: UK
Junior Member
Great Document - thank you for your help.
Re: Secure Data over Database Link [message #616098 is a reply to message #616087] Thu, 12 June 2014 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I wrote it. Thank you for your comment. Smile

Re: Secure Data over Database Link [message #616513 is a reply to message #616098] Tue, 17 June 2014 14:42 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Michel Cadot wrote on Thu, 12 June 2014 15:29

I wrote it.


Very good information Michel. Thanks. I just read it, and indeed you have elaborated it quite well.

P.S. : I found few typo errors, for example, in the introduction part, spelling of "licencied" is incorrect. Do you mind if I edit the wiki if I find such typos?

Regards,
Lalit
Re: Secure Data over Database Link [message #616516 is a reply to message #616513] Tue, 17 June 2014 14:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I didn't write this sentence, it is an update made by another one (see history: 13:04, 29 January 2014‎).
Yes, you can update it, this is a OraFAQ wiki not my blog.
Wiki administrators check the updates to verify they are pertinent (you can't imagine the number of persons adding spam or gibberish into the pages).

Re: Secure Data over Database Link [message #616518 is a reply to message #616516] Tue, 17 June 2014 14:59 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Michel Cadot wrote on Wed, 18 June 2014 01:22
you can't imagine the number of persons adding spam or gibberish into the pages


And it never stops /forum/fa/1587/0/

P.S. : Corrected the typo in the wiki page.

[Updated on: Tue, 17 June 2014 15:00]

Report message to a moderator

Re: Secure Data over Database Link [message #616530 is a reply to message #616518] Wed, 18 June 2014 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Are you sure you did it? I don't see the modification.
Note when you save the page you first see a preview and have to confirm it gibing the code at the bottom.

Re: Secure Data over Database Link [message #616531 is a reply to message #616530] Wed, 18 June 2014 00:43 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Done. I forgot save page after preview.
Re: Secure Data over Database Link [message #616532 is a reply to message #616531] Wed, 18 June 2014 00:44 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, now I see it. Smile

[Updated on: Wed, 18 June 2014 01:03]

Report message to a moderator

Previous Topic: How to deploy BIG-IP ASM with Oracle Database Firewall ???
Next Topic: User Getting Locked
Goto Forum:
  


Current Time: Thu Mar 28 17:55:41 CDT 2024