Re: userid password

It is a really useful technique, re-creating the password using the stored encrypted value, for 'becoming a user' to test the application from their perspective. You save the encrypted value, change the users password, login and test as that user, then restore the encrypted password value.

Glenn Stauffer

Halina Monka <monka_at_ibm.net> wrote in article <31EEB284.3B0A_at_ibm.net>...
> Dean Cunningham wrote:
> >
> > BELAEN Lydia wrote:
> > >
> > > Is it possible to check the password of a user in oracle without
> > > connecting to the database by that userid ?
> >
> > Yes, but you can only see an encrypted version of it, last I remember
> > and sorry I don't know which system table
>
> You may only find encrypted password. It is in dba_users table.
> You may use encrypted password if you need re-create user with same
> password. It can be scripted.
> Halina Monka
>
Received on Thu Jul 18 1996 - 00:00:00 CEST