Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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" - UnknownReceived on Thu Jun 01 2006 - 10:48:11 CDT
![]() |
![]() |