[Fwd: passwords in different instances]
- From: Ingrid Voigt <GiantPanda@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- 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.
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
