Re: Decoding Oracle password

It seems to me that Oracle keeps track of the password you entered as you logged in. When using the gateway to DB2 via a database link, we must enter the password in upper case. Oracle accepts the password in either upper or lower case but DB2 demands upper case. If we enter the password in upper case, the link to DB2 works. If we enter the password in lower case, DB2 rejects the password.

This might be evedence of decoding the password. But I think Oracle just remembers your login password.

Sreeni Karpurapu wrote:
>
> In my opinion encoded/ encripted passwords are not the same for identical
> passwords! You might want to verify from dba_users (Select username,
> password from dba_users)
>
> Apparantly Oracle decodes the passwords :>)
>
> Sreeni
> --
> ========================================
> Sreeni Karpurapu
> DBA
> Miracle Software Systems
> Southfield, MI 48034
> ========================================
>
> Ari Kaplan <akaplan_at_interaccess.com> wrote in article
> <5vu62a$cra$1_at_nntp3.interaccess.com>...
> >
> > Oracle compares the encoded passwords on each database. If there were an
> > algorithm to decode the passwords, we'd all be in trouble.
> >
> > -Ari Kaplan
> > Independent Oracle DBA Consultant
> >
 

-- 
John P. Higgins      Voice:    (309)765-7868
Deere & Company      Fax:      (309)765-7800
John Deere Road      Internet: jh33378nospam_at_deere.com
Moline, IL 61265     Opinions: My Own