RE: Encryption

Depending on the version:  

Starting w/ 8i, I think, was DBMS_OBFUSCATION_TOOLKIT  

Starting w/ 10g is DBMS_CRYPTO_TOOLKIT  

I don't have much experience w/ either so, I'll leave it to others to comment on their use......  

-Mark

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Burton, Laura Sent: Tuesday, November 15, 2005 5:03 PM To: oracle-l_at_freelists.org
Subject: Encryption

Scenario:  

We have a new user which will be created an account in an application (not a database user) by inserting into a table. When this occurs a trigger is fired to insert the user into other tables. A field in one of the tables is an encrypted password. We want the initial password to be the person's ssn, which was input into the table which fired the trigger. Does oracle have an encryption process that can be executed to encrypt the ssn, in this example, before inserting into another table? We have looked on OTN but could not find anything. I know the easy thing to do would be to use a generic password so that we could just move the encrypted password in every time, but our user wants ssn so that it will be unique to that user until they are prompted to change their password on the initial log in to the application. Again, this is not a database user.  

Thanks for the feedback.  

Laura

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 15 2005 - 16:10:21 CST