Re: passwords in different instances
Date: Fri, 19 Jun 2009 07:57:39 +0200
Message-ID: <8580d4110906182257y74c7a4agcc210e152361d0d9_at_mail.gmail.com>
I believe they will have the same password if they have the same username. Since those to are concatenated ant then hashed, the hash value you get to with one password would not be the same for two different user names. I'm not sure, but it doesn't feel as OP or the thread has made it clear if the user in the second database will have the same user name or not.
Mathias
On Fri, Jun 19, 2009 at 5:17 AM, nilesh kumar <nileshkum_at_gmail.com> wrote:
> Yes they will have the same password. It wouldn't be possible if the user
> exists in the same database, since they are in two different databases so
> there password will match.
>
> Thanks
> Nilesh
>
>
> On Thu, Jun 18, 2009 at 4:52 AM, <TESTAJ3_at_nationwide.com> wrote:
>
>>
>> that should work as a full import does a alter user username identified by
>> values, and I have taken the hex value passed thru a password cracker and
>> found a password that with the exact same hex value on a different db and it
>> worked.
>>
>> all this is 10g and below, 11g is a different animal with case sensitive
>> password and the such.
>>
>> joe
>>
>> _______________________________________
>> Joe Testa, Oracle Certified Professional
>> (Work) 614-677-1668
>> (Cell) 614-312-6715
>>
>> Interested in helping out your marriage?
>> Ask me about "Weekend to Remember"
>> Dec 11-13, 2009 here in Columbus.
>>
>>
>>
>> From: <genegurevich_at_discover.com> To: oracle-l_at_freelists.org Date: 06/17/2009
>> 06:21 PM Subject: passwords in different instances Sent by:
>> oracle-l-bounce_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-lReceived on Fri Jun 19 2009 - 00:57:39 CDT