Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PASSWORD
P Jeromel wrote:
>
> 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."
You can do the steps I listed above within PL/SQL using dbms_sql to issue the DDL, or use "execute_immediate" in 8i.
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Mon Jun 21 1999 - 09:16:40 CDT