[Fwd: passwords in different instances]

No. The dba_users password column stores a hash value
of the concatenation USERNAME || PASSWORD.

If the two usernames are different, user2 will most likely
not have any password at all. If one is a prefix of the
other, the passwords will have the reverse relation.
If the usernames are the same, then the passwords will be
identical.


Regards
Ingrid




-------- Original Message --------
Subject: passwords in different instances
Date: Wed, 17 Jun 2009 17:17:58 -0500
From: <genegurevich@xxxxxxxxxxxx>
Reply-To: genegurevich@xxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx

Hello:

If I have two users existing in two separate databases (10.2.0.3) and these
users have  the same value in the password column of the dba_users
view, does this mean that they have the same passwords?

In other words. if I enter the following command:

alter user USER1 identified by values 'XXXXXXX'

where XXXXXX = select password from dba_users where username = 'USER2'

will the USER1 and USER2 have the same passwords?

thank you

Gene Gurevich



Please consider the environment before printing this email.


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: