[Fwd: passwords in different instances]
Date: Thu, 18 Jun 2009 00:36:55 +0200
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.
- Original Message -------- Subject: passwords in different instances Date: Wed, 17 Jun 2009 17:17:58 -0500 From: <genegurevich_at_discover.com> Reply-To: genegurevich_at_discover.com To: oracle-l_at_freelists.org
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?
Please consider the environment before printing this email.
http://www.freelists.org/webpage/oracle-l Received on Wed Jun 17 2009 - 17:36:55 CDT