Applying SSHA algorithm within Oracle [message #298236] |
Tue, 05 February 2008 07:34 |
AudiLover
Messages: 3 Registered: February 2008 Location: PA
|
Junior Member |
|
|
Hi,
I'm trying to figure out the easiest way to authenticate users against Oracle for passwords that are brought into the database from an outside source and are already encrypted using SSHA.
The scenario is that the passwords are pulled into Oracle (from an external LDAP directory) and then when the user tries to authenticate, the authenticating application is able to pass the unencrypted value entered by the user into a stored procedure in Oracle. From there I need to apply the same salted hash used to generate the value already in the database to do a match.
So, from within this stored procedure I either need to call an external process to hash the text entered by the user or have Oracle do this (if it's supported). We already do this with a different encryption algorithm for other users but now need to add in support for SSHA (coming from this secondary source) and I haven't had much luck finding info on how to do this.
Any suggestions?
|
|
|
|
Re: Applying SSHA algorithm within Oracle [message #298264 is a reply to message #298238] |
Tue, 05 February 2008 08:37 |
AudiLover
Messages: 3 Registered: February 2008 Location: PA
|
Junior Member |
|
|
Thanks Michel, but I don't see any info in here about support for a salted hash (SSHA). If anyone knows if this is supported in the package, please let me know. Otherwise I would need to make a call to an external package that can handle this (and I'm trying to avoid this).
-Chris
|
|
|
|
|