Re: Copying Username & Passwords from one instance to another?

: you_at_somehost.somedomain (Your Name) wrote:  

: >Is there a way to copy a username and password from one instance to
: >another and retain the same password? I need to migrate users from an old
: >instance to a new one and I would like all users to retain their old
: >passwords. Thanks in advance.

In the database from which you wish to copy, you can do something like this:

	select 'create user ' || username, 
               ' identified by values ''' || password ||''';'
               from sys.dba_users
	/

Spool the above into a file. Remove all non-sql statement, and execute it on the new database.

HTH,
Leng.

--
Leng Kaing
DBA - Directory Technology P/L
Email: lkaing_at_ventnds1.telecom.com.au
Ph: +61-3-9892-9081  Fax: +61-3-9892-9344