Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Migrating Userids

Re: Migrating Userids

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







As an afterthought... You should filter out SYS and SYSTEM.



Mike Morgan


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

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


 FROM DBA_USERS



WHERE USERNAME NOT IN ('SYS','SYSTEM')



 /
Received on Tue Sep 09 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US