OraFAQ Forum: Security » Secure Data over Database Link

Home » RDBMS Server » Security » Secure Data over Database Link (RDBMS 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Secure Data over Database Link [message #616016]

Wed, 11 June 2014 10:31

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.

Report message to a moderator

Re: Secure Data over Database Link [message #616020 is a reply to message #616016]

Wed, 11 June 2014 10:46

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

Report message to a moderator

Re: Secure Data over Database Link [message #616022 is a reply to message #616016]

Wed, 11 June 2014 10:50

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Secure Data over Database Link [message #616023 is a reply to message #616022]

Wed, 11 June 2014 10:56

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.

Report message to a moderator

Re: Secure Data over Database Link [message #616025 is a reply to message #616023]

Wed, 11 June 2014 11:46

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read Network Encryption

Report message to a moderator

Re: Secure Data over Database Link [message #616087 is a reply to message #616025]

Thu, 12 June 2014 04:17

ajnewbs
Messages: 8
Registered: June 2014
Location: UK

Junior Member

Great Document - thank you for your help.

Report message to a moderator

Re: Secure Data over Database Link [message #616098 is a reply to message #616087]

Thu, 12 June 2014 04:59

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I wrote it. Thank you for your comment. Smile

Report message to a moderator

Re: Secure Data over Database Link [message #616513 is a reply to message #616098]

Tue, 17 June 2014 14:42

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

Report message to a moderator

Re: Secure Data over Database Link [message #616516 is a reply to message #616513]

Tue, 17 June 2014 14:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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).

Report message to a moderator

Re: Secure Data over Database Link [message #616518 is a reply to message #616516]

Tue, 17 June 2014 14:59

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator