RE: Migrate users from 10-11
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Freek.DHooge@xxxxxxxxx>, <niall.litchfield@xxxxxxxxx>, <stmontgo@xxxxxxxxx>
- Date: Wed, 30 Nov 2011 11:20:01 -0500
dba_users has some spots. The identified by values clause now causes an
ora-00600. (Turns out this trick has never been supported by oracle).
It works from 11g also:
select 'alter user &&v_user identified by values '||''''||b.password||''''||';'
from dba_users a, sys.user$ b
where a.user_id = b.user# and a.username = upper('&&v_user');
DESC DBA_USERS
Name
----------------------------------------
...
EXTERNAL_NAME
PASSWORD_VERSIONS
EDITIONS_ENABLED
AUTHENTICATION_TYPE
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of D'Hooge Freek
Sent: Wednesday, November 30, 2011 10:55 AM
To: niall.litchfield@xxxxxxxxx; stmontgo@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Migrate users from 10-11
Niall,
It is true that the hash changed in 11 (with case sensitive passwords now), but
the old hashes are still accepted.
I think there is even a flag that tells you if this the password is using the
old or the new method.
Kind regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Niall Litchfield
Sent: woensdag 30 november 2011 16:48
To: stmontgo@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Migrate users from 10-11
The password hash changes in 11! Why didn't you just allow datapump to
create the users (or whisper it not in Gath) just perform a database
upgrade?
On Wed, Nov 30, 2011 at 3:11 PM, steve montgomerie <stmontgo@xxxxxxxxx>wrote:
> Greetings Oracle List!
> We're moving an Oracle Database to a new Server upgrading from 10 to
> 11 with Datapump. Can we migrate the schema's without
> knowing/changing the passwords?
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
