Solved

Oracle SQL Plus security question

Posted on 2014-03-26
3
550 Views
Last Modified: 2014-03-26
Greeting,

I use SQL plus worksheet and SQL plus 10 to connect to my remote oracle database.
I'm wondering if the password and data are encrypted when I making the connection.

Thanks.
0
Comment
Question by:mrong
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
Geert Gruwez earned 500 total points
ID: 39955865
by default only the password is not sent as plaintext

to setup encryption between an oracle instance and the clients
follow this:
http://kb.berkeley.edu/page.php?id=23274

the doc also contains a verification process to check if the current traffic is encrypted
0
 

Author Comment

by:mrong
ID: 39955882
Geert Gruwez,

The link you provided shows how to set up encryption on the client side.
Does encryption settings need to be done on the server side?
Thanks.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 39956239
yes, on the server side, things need to be done as well
it's stated on the site, but it's not very clear

Your DBA must have installed the Oracle server software with the Advanced Security option, and the DBA must have configured the database listener to at least allow encrypted sessions and checksumming. Your DBA will need to provide you with the available encryption and checksum algorithms for your instance.

Advanced Security option allows the database to setup encryption

you could check via view dba_registry if any encryption component is active
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now