Re: Need help on encryption

Frank van Bortel wrote:
> Tubby schreef:
> > I have a few columns in a table for which the data needs to be
> > encrypted. How do I go about creating the required Encryption and
> > Decryption using the DBMS_Obfuscation_Toolkit?
> >
> > I was unsuccessful when I wrote Triggers on the Table requiring
> > Encryption as it had a Mutating effect. One was a Statement and the
> > other for Each Row.
> >
> > Any help would be greatly appreciated.
> >
> In 10G Release 2, use encrypted columns (transparant data
> encryption).
> I have an entry on that:
> http://vanbortel.blogspot.com/2005_07_01_vanbortel_archive.html
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

But the problem with transparent data encryption is that Oracle automatically decrypts the data for the user if they have select on the table. In most cases if you need to encrypt the data you are encrypting it from the majority of the users who select on the table. That is not to say the feature does not have merit or Frank was wrong for mentioning the option. Sensitive data can be protected via the feature from users skimming data from scans of export files, hot backups files, or direct reading of the database files. The feature just does not eliminate the need to separately encrypt sensitive data.

IMHO -- Mark D Powell -- Received on Fri Jun 02 2006 - 13:27:32 CDT