Offline doubt - Password checking in Oracle..

From: Arul kumar <rakumar_at_mahindrabt.com>
Date: Thu, 01 Feb 2001 23:14:26 -0800
Message-ID: <F001.002A884D.20010201224522@fatcity.com>

Hi Gurus,

I am working on a Sybase to Oracle migration project where i need to write a function which accepts username , old password and new password as parameters and modifies the account(Oracle Schema ) with the new password.
If the password is correct, then only password modification should take place.

Now, my question is :

How to validate the user given password as correct or not? (becos Oracle stores password by encrypting it!).

Any suggestions will be of great help to me.

TIA,
Arul.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Arul kumar
  INET: rakumar_at_mahindrabt.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 02 2001 - 01:14:26 CST