Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to compare passwords?
If you are going to go to the database to
get the encrypted password, why not
simply try connecting to the database
with the supplied password and see if
you get an error ?
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Chris Ermlich wrote in message ...
>Hi folks,
>I'm running into a verification problem. We are trying to provide an
>authentication layer to an application where the app will check if the user
>entered a valid password. I can get the encrypted pw out od DBA_USERS. Is
>there a way to run the password encryption manually so I can compare the
>submitted password to the encrypted one out of DBA_USERS? Obviously, there
>is no way of getting the "real" password out of Oracle. The authentication
>is happening before the user logs on, so I can't just trap an invalid logon
>(e.g. viaVisual Basic ERR function).
>Any advise would be appreciated.
>Thanks,
>Chris Ermlich
>cermlich_at_swri.edu
>
>
>
Received on Tue Feb 08 2000 - 13:11:52 CST