RE: create user with existing password
Date: Fri, 4 Mar 2011 14:40:51 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F0ECD60C1_at_us-bos-mx022.na.pxl.int>
That started in 11g R1 which also introduced case sensitive passwords by default.
Dick Goulet
Senior Oracle DBA/NA Team Leader
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of D'Hooge Freek
Sent: Friday, March 04, 2011 2:39 PM
To: rodd.holman_at_gmail.com; oracle-l_at_freelists.org
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.
regards
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rodd Holman
Sent: vrijdag 4 maart 2011 20:08
To: oracle-l_at_freelists.org
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_at_austinisd.org 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_at_hotmail.com>
Subject: � � � �create user with existing password
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 04 2011 - 13:40:51 CST