Re: How to trap password

Chris Forbis wrote:

> 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!
>

A password change must hit the sys.user$.password table/column if you are using database auth. Thats a must for this solution. A after update trigger on this could keep the PW table up to date.

/Svend Received on Tue Jul 02 2002 - 13:31:26 CDT