Re: encryption

From: <wblanchard_at_oshkoshcorp.com>
Date: Tue, 19 Mar 2013 16:17:53 -0500
Message-ID: <OFA7DA0C85.826D6DF5-ON86257B33.0074D28E-86257B33.0074FEB3_at_oshkoshcorp.com>

I used dbms_crypto on a few columns in a database and can send you the scripts I wrote. The only downside was that you need to pass that column through an encrypt or decrypt function. If you're talking about tablespaces or the entire database I definitely wouldn't recommend my encryption routines.

Thank you,

WGB From: Gints Plivna <gints.plivna_at_gmail.com>

To:     Brian.Zelli_at_roswellpark.org
Cc:     "oracle-l (oracle-l_at_freelists.org)" <oracle-l_at_freelists.org>
Date:   03/19/2013 10:02 AM
Subject:        Re: encryption
Sent by:        oracle-l-bounce_at_freelists.org

There is also dbms_crypto package, which AFAIK is not extra cost option. I assume one can also find more or less free java code, load it in db and do encryption. However never done that myself. TDE is part of Advanced Security, which is extra cost option for EE. Gints

2013/3/19 Zelli, Brian <Brian.Zelli_at_roswellpark.org>

> So is TDE the only way to encrypt from the db level? And is that an
added
> expense? I am on HPUX.
> ciao,
> Brian
>
> ----------------------------------
> Brian Zelli
> Senior Database Administrator
> Enterprise Apps/Sys Integration
> Roswell Park Cancer Institute
> (716) 845-4460
> brian.zelli_at_roswellpark.org
> ----------------------------------
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee
or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l





Although this e-mail and any attachments are believed to be free of any virus or other defect which might affect any computer system, it is the responsibility of the recipient to check that it is virus-free and the sender accepts no responsibility or liability for any loss, injury, damage, cost or expense arising in any way from receipt or use thereof by the recipient.

The information contained in this electronic mail message is confidential information and intended only for the use of the individual or entity named above, and may be privileged.  If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.  If you have received this transmission in error, please  contact the sender immediately, delete this material from your computer and destroy all related paper media.  Please note that the documents transmitted are not intended to be binding until a hard copy has been manually signed by all parties.
Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 19 2013 - 22:17:53 CET