Validating Oracle Passwords

From: <tonysheehan_at_my-dejanews.com>
Date: Tue, 27 Oct 1998 19:33:41 GMT
Message-ID: <71576l$ac2$1@nnrp1.dejanews.com>

How can I validate an Oracle password using a PL-SQL code block, function or procedure?

I have a screen in my client server application that acts as a user password change. I would like to be able to prompt the user for their old password and validate it against the database to ensure that this is the correct user. The user could then proceed to change their password.

Is this possible? Remember I cannot make use of SQL*Plus since this is a client server application.

Any ideas would be welcome.

thanks,

Tony

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 27 1998 - 13:33:41 CST