Hi,
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.
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.
Reply With Quote
Bookmarks