Re: Need help on encryption

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.
>

Which version? In 10g, use the DBMS_CRYPTO supplied package. Details can be found here:

http://download-east.oracle.com/docs/cd/B19306_01/network.102/b14266/apdvncrp.htm#i1007112

If not 10g, then read the Securities doc for your version.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown