Re: Migrating Userids

From: Andy Young <young_at_pwgsc.gc.ca>
Date: 1997/09/12
Message-ID: <5vbk2k$8gc3@piper.ncr.pwgsc.gc.ca>#1/1

Deborah,

I butchered the code in our connect_as_user script to get this SQL, but I have not tried it. The resulting text looks good.

set linesize 132
set pagesize 999
set heading off

spool alters.sql
select

   'alter user '||username||
   ' identified by values '||
   ''''||password||''''||
   ';'

 from sys.dba_users
 order by username
;
spool off

Andy Young
Public Works and Government Services Canada Ottawa, ON, Canada
young_at_pwgsc.gc.ca

In article <19970909174800.NAA02570_at_ladder01.news.aol.com>, Debor19071 says...
>
>We have ALOT of Oracle userids we need to copy from 1 instance to another.
> The tools we are using do not copy the passwords properly.
>
>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.
>
>Please respond as quick as you can - we need to do this soon.
>Thanks very much!
>
>Deborah Dawicki
>dawicki_at_princeton.edu
>
Received on Fri Sep 12 1997 - 00:00:00 CDT