Re: Migrate users from 10-11

  • From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 30 Nov 2011 15:58:57 +0000

Hi Niall,

On 30/11/11 15:48, Niall Litchfield wrote:
> The password hash changes in 11!
Did it? I never saw that in new features.

Anyway, I see the same hash in my 11g database for a user that exists in 
a 9i database - both have the same password.

Mind you, getting the hash has definitely changed - it's in DBA_USERS in 
9i and sys.user$ in 11g. NULLs all round in 11g DBA_USERS.

I can even login to the 11g user - which was created using a script with 
the "identified by values" extracted from 9i.


Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767

Other related posts: