Re: Migrating Userids

From: Mike Morgan <mmorga2_at_amfam.com>
Date: 1997/09/09
Message-ID: <01bcbd51$edd1c6c0$7c38c8a5@mxm014pc>#1/1

Deborah,

You might try creating a dynamic SQL file from the source database and executing it on the target.
For example:

SELECT 'create user '||USERNAME||' identified by values '''||

       PASSWORD||''' default tablespace '||DEFAULT_TABLESPACE||
       ' temporary tablespace '||TEMPORARY_TABLESPACE||';'

from dba_users
/

This selects the appropriate columns from DBA_USERS needed to create a user in another instance. Note the use of "BY VALUES" which passes the encrypted form of the password. Also, when using the "BY VALUES" clause, the password should be enclosed in single quotes. (That's the reason for the 3 consecutive quotes surrounding PASSWORD.)

Mike Morgan
Compuware Corporation

++++++++++++++++++++++++++++++++++++++++++++++

Deborah asked ....
| We have ALOT of Oracle userids we need to copy from 1 instance to
 another.
|
| Do you know of a way to properly pass the passwords over from 1 instance
| to another in the least laborious way as possible? We don't want to
 export
| every user.

|

| Deborah Dawicki
| dawicki_at_princeton.edu
|
|
Received on Tue Sep 09 1997 - 00:00:00 CDT