Re: Oracle and Encryption

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 10 Oct 2006 19:52:17 +0200
Message-ID: <eggm8s$n4f$1@news3.zwoll1.ov.home.nl>

Pedro Lopes schreef:
> If running on 10gR2, TDE (transparent data encryption) is the way to go. >

No, it is not, because anyone granted to see the column can see it's contents, and the OP said:

> I would like to keep it in its encrypted form in the
> database but I would like to be able to show it to certain privileged
> people based on a password.

Why do you think TDE is called Transparant? I had some trouble with proving the encryption, too. Looks for TDE how to on: http://vanbortel.blogspot.com/2005_07_01_vanbortel_archive.html

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Tue Oct 10 2006 - 12:52:17 CDT