I want to encrypt the 'password' and store it in the database and decrypt it on a 'later' date.
I am using the dbms_obfuscation_toolkit package as suggested by oracle.
Problem is, when I use the dbms_obfuccation package, the data will be converted to raw and then encrypted and stored again in the raw variable. For the display purpose we convert the raw variable using - rawtohex .
Now, I want to just encrypt the data and store in the table.
1) what should be the column type for storing this encryted password .
2)Can I store the encrypted data in the varchar2 datatype column and if so how do I decrypt this data later.
Anybody who has stored the encrypted field ,please help me
Did you use the procedure
Hi, 11th May 2001 21:14 hrs *******
This link throws you more on the encryption of data as well as index datas plus the Oracle partners products such as Protegrity giving solutions for your problem.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Click Here to Expand Forum to Full Width