"Aziz" <azizbr_at_rogers.com> wrote in message news:<G7ak9.39628$q41.32983_at_news02.bloor.is.net.cable.rogers.com>...
> Valodia,
>
> How can I encrypt and decrypt data in Oracle? I am storing user PINs in a
> table (not in DBA_USER). I need to encrypt them. Is there any Oracle DBMS
> utlity that I could use for it. Can you or any one else provide me with an
> example or reference where I could read about it.
You should take a look on DBMS_OBFUSCATION_TOOLKIT. It uses DES (in 9i
Triple DES) to encrypt or decrypt data in database.
Using of this utility was mentioned here in newsgroup many times in
past. Look in archives of this NG for more exhaustive information.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Wed Sep 25 2002 - 05:15:51 CDT
