RE: create user with existing password

  • From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
  • To: "Freek.DHooge@xxxxxxxxx" <Freek.DHooge@xxxxxxxxx>, "rodd.holman@xxxxxxxxx" <rodd.holman@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 7 Mar 2011 15:00:18 +0000

I have never been that keen on altering the default profile. No particular 
justification to support my view but I like to leave sys/system and dbsnmp 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of D'Hooge Freek
Sent: 04 March 2011 19:39
To: rodd.holman@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: create user with existing password

Also, keep in mind that in 11g (not sure it was since 11gR1 or only in 11gR2) 
passwords expire by default after 180 days... .
So best to either create a new profile (which I prefer) and put the users in 
this profile or alter the default profile.


Freek D'Hooge
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Rodd Holman
Sent: vrijdag 4 maart 2011 20:08
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: create user with existing password

This works,
I'm currently using this to move users from a 10g to 11g database.  The kicker 
is to remember that 11g, by default, now uses case sensitivity in the 
passwords.  So, if they entered their password in all lower case in 10g, that's 
still what they need to do.

On 03/04/2011 11:31 AM, japplewhite@xxxxxxxxxxxxx wrote: 
I've used this SQL in a script that runs against the old DB and gets all Users 
but the built-in ones like Sys, System, etc. (User_ID > <SomeInteger>).  It 
makes sure to set their Temp tablespace correctly, in case it wasn't - some of 
our Apps create Users with Temp tablespace = System.  I do System and Role 
privs in different scripts, as well as tablespace Quotas.  Then I take those 
files to the new DB and run them in order. 

Select 'Create User '            || UserName ||           || Chr(10) || 
       'Identified by Values ''' || Password || ''''      || Chr(10) || 
       'Default Tablespace '     || Default_Tablespace    || Chr(10) || 
       'Temporary Tablespace Temp ;' 
From   DBA_Users 
Where  User_ID       > 33 
Order By UserName 

Hope this helps. 

Jack C. Applewhite - Database Administrator

From:        P D <pdba1966@xxxxxxxxxxx> 
Subject:        create user with existing password 

Wm Morrison Supermarkets Plc is registered in England with number 358949. The 
registered office of the company is situated at Gain Lane, Bradford, West 
Yorkshire BD3 7DL. This email and any attachments are intended for the 
addressee(s) only and may be confidential. 

If you are not the intended recipient, please inform the sender by replying to 
the email that you have received in error and then destroy the email. 
If you are not the intended recipient, you must not use, disclose, copy or rely 
on the email or its attachments in any way. 

This email does not constitute a contract in writing for the purposes of the 
Law of Property (Miscellaneous Provisions) Act 1989.

Our Standard Terms and Conditions of Purchase, as may be amended from time to 
time, apply to any contract that we enter into. The current version of our 
Standard Terms and Conditions of Purchase is available at:

Although we have taken steps to ensure the email and its attachments are 
virus-free, we cannot guarantee this or accept any responsibility, 
and it is the responsibility of recipients to carry out their own virus checks. 

Other related posts: