[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • Last Modified:

Oracle SQL Plus security question

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
mrong
Asked:
mrong
  • 2
1 Solution
 
Geert GruwezOracle dbaCommented:
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
 
mrongAuthor Commented:
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
 
Geert GruwezOracle dbaCommented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now