Howard J. Rogers wrote:
>
> 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
True but presumably the hash functions are not different between
versions of Oracle, otherwise the password value in user$ would have to
be updated whenever you upgraded.
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
Coming Soon! "Oracle Insight - Tales of the OakTable"
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"
------------------------------------------------------------
Received on Thu Dec 23 2004 - 08:23:53 CST
