Re: identified by values compatibility ?

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
>
>

Because what you read in the export dump file is a hash value.... and do you know whether the hash algorithm employed in 9i is the same as the one used in 8i? Because I certainly don't. And even if it is the same hash algorithm, what do you suppose it is a hash of? Username (yours are different)? Database name (is yours the same?)? The unique DBID (yours will be different)? Database Creation Time?? Oracle Version???

Who knows? Point is, no-one does. But any and all of those could affect what the hash value for the same password would be. So attempting what you're attempting is a brave experiment, but it's now time to stop!

Regards
HJR Received on Tue Dec 21 2004 - 16:02:00 CST