Re: Need help on encryption

I am sorry I did not mention this when I created the message.

  The Database Version is 9.2. Life probably would have been easier had it been 10.

Arto Viitanen wrote:
> Tubby wrote:
> > 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.
> >
>
> I just read a book which handles the subject (and others):
> Nanda Arup, Fuerstein Steven "Oracle PL/SQL for DBAs" by O'Reilly.
> The book handles both DBMS_Obfuscation_Toolkit and DBMS_CRYPTO packages.
> Also did you know that 10G2 has builtin support to encrypt fields?
> Oracle Magazine Sep/Oct 2005 has an article of the subject (and it is
> written by Arup Nanda !)
>
> --
> Arto Viitanen, CSC Ltd
> Espoo, Finland
Received on Mon Jun 05 2006 - 08:08:36 CDT