How to trap password

From: Chris Forbis <chrisforbis_at_yahoo.com>
Date: 2 Jul 2002 06:18:00 -0700
Message-ID: <f2dc430d.0207020518.32771f37@posting.google.com>

I need to store a users password in a format that can be used by my application without login a user in (I have an user that will have access only to the PW table)

I have a table like this
USER_ID : OracleUserID
PW_ENCODED : MD5 encoded password

I would like this MD5 encoded password to always be valid for a user. I need to be able to update it when a user alters there password. Ideas?

Is there a on alter password trigger?

Or better yet how does Oracle valid a user against a password, that would be a better place to get my job done.

Thanks! Received on Tue Jul 02 2002 - 08:18:00 CDT