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 Fri Jun 02 2006 - 03:02:47 CDT
