Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to trap password
what is the problem you are trying to solve?
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Chris Forbis" <chrisforbis_at_yahoo.com> wrote in message news:f2dc430d.0207020518.32771f37_at_posting.google.com...Received on Tue Jul 02 2002 - 09:21:04 CDT
> 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!