Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DBMS_OBFUSCATION_TOOLKIT.DES3 [en/de]cryption

 
peter cooke
Ranch Hand
Posts: 317
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Over the years I have had two projects that would enrypt/decrypt values for specific columns in a DBMS table from a Java class. Once on oracle, and once on DB2. So I know it can be done.

I have just spent about 40 minutes searching the internet for an example of a java jdbc class that uses DBMS_OBFUSCATION_TOOLKIT.DES3[en/de]crypt.


I recall call something about a prepareCall command but that is about it.




similar example of what trying to accomplish.

given a table called APP_USER that contains login id, password, social security number.

insert into APP_USER (u_id, login_id,password, ssn) values (GENERATED_PK,'mylogin', dbms_obfuscation_toolkit.DES3Encrypt (unenrypted_input_string => v_password, key_string => v_key), encrypt ssn);


select dbms_obfuscation_toolkit.DES3decrypt(input_string => app_user.password, key_string => key) from app_user where login = ?
)


Anyone know of URL references for what I am trying to do
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64631
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please do not post the same question more than once.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic