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