Re: create user with existing password

From: <japplewhite_at_austinisd.org>
Date: Fri, 4 Mar 2011 11:31:01 -0600
Message-ID: <OF56F1B908.4D6C2D8F-ON86257849.005FA9FE-86257849.00603B61_at_austinisd.org>

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 Austin I.S.D. - MIS Department
512.414.9250 (wk) / 512.935.5929 (pager)

From: P D <pdba1966_at_hotmail.com>
To: <oracle-l_at_freelists.org>
Date: 03/04/2011 11:11 AM

Subject:        create user with existing password
Sent by:        oracle-l-bounce_at_freelists.org

Does anybody have a dynamic sql script that pulls user definitions (including current passwords) into a text file? I need to move users from a 10g database over to an 11g database. They want to keep their current passwords.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 04 2011 - 11:31:01 CST