[rwitalka]

There is a databse stored procedure that will do the trick for you.

pkg_gl_password.validate_password('user name','password')

This is a boolean function that will return true if you supply the correct password for the user id. We are running version 5.5, CU2. I don't know in what other versions this function is available.