Re: identified by values compatibility ?

From: Anurag Varma <anuragvidya_at_gmail.com>
Date: 21 Dec 2004 13:16:36 -0800
Message-ID: <1103663796.718253.11410@z14g2000cwz.googlegroups.com>

zeb wrote:
> Hi,
>
> I have to import a user (schema) from user8 (8i) to user9 (9i).
> I created the user9 in the 9i database
> with identified by values 'XXXXXXX'
> (gotten from imp show=y )
> when I try to connect with user9
> with the password it was in the 8i database
> I am told that the passowrd is not correct ...
>
> Is it a normal behavior ?
> Why the same crypted password
> doesn't give the same passord whithin 8i and 9i ?
>
> Thanks in advance...
>
> Oracle 8i/9i
> Windows 2000

AFAIK: the passwords are salted with the username. So a password for user8 .. will only work for user8 (and not user9).

HTH Anurag Received on Tue Dec 21 2004 - 15:16:36 CST