Re: How to trap password

Niall,

My end goal is to be able to have a function like this:

IsUserValid(username, password)

This needs to check the username and check the password against oracle. I could do a connect, but this take about 1.5-2.0 seconds on my system. I already have a pool of connecitons and because all I need to do is check a login, I really hate to connect for this.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3d21b6d1$0$236$ed9e5944_at_reading.news.pipex.net>...
> 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...
> > 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 - 20:33:02 CDT