[Fwd: passwords in different instances]

From: Ingrid Voigt <GiantPanda_at_gmx.net>
Date: Thu, 18 Jun 2009 00:36:55 +0200
Message-ID: <4A397007.9030706_at_gmx.net>



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_at_discover.com> Reply-To: genegurevich_at_discover.com To: oracle-l_at_freelists.org

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 Received on Wed Jun 17 2009 - 17:36:55 CDT

Original text of this message