Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PASSWORD
Does anyone know how to check if a password for a user is correct during the
execution of a stored proc?
(For use within a Change_Password sort of routine).
The only way I can figure is to:
1) Create a database link to the current database connecting by the user and
the password supplied by the user (as their current password)
2) Checking if you can do a select or something via the db link.
The problem I have with this, is that, I need to hard code the SID (or is it
TNSNAME
entry) into the DB_Link creation command.
Does ne1 know of a better way?
Thanks.
Paul
Connor McDonald wrote:
> Gérard PIOCH wrote:
> >
> > How can I find a password that a user forgot? it is a question well of
> > finding and not to allot new!
> > Oracle 7.3.4
> > THANK YOU.
>
> If they have any ideas about what it was,
>
> try altering there passowrd to there guesses and see if the encoded
> value matches...other that that, you're out of luck
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Sun Jun 20 1999 - 19:18:06 CDT