RE: Encryption
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <BurtonL@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Nov 2005 17:07:46 -0500
Check out dbms_obfuscation
_____
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Burton, Laura
Sent: Tuesday, November 15, 2005 5:03 PM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
