Re: script to create users like existing users
From: Paul Druker <pdruker_at_metaway.com>
Date: Wed, 22 Mar 2000 01:08:24 GMT
Message-ID: <c2VB4.773$h3.7525_at_typhoon.southeast.rr.com>
Date: Wed, 22 Mar 2000 01:08:24 GMT
Message-ID: <c2VB4.773$h3.7525_at_typhoon.southeast.rr.com>
Gerard,
[Quoted] What exactly do you need to modify?
For example, to change temporary tablespace for all your users you might write the following script:
set echo off termout off feedback off
spool gen_temp_tbs.sql
select 'alter user '||username||' temporary tablespace NEW_TEMP_TBS;'
from dba_users
where temporary_tablespace = 'OLD_TEMP_TBS';
spool off
start gen_temp_tbs
Regards,
Paul Druker
"Gérard De Maeyer" <gerard.de.maeyer_at_pandora.be> wrote in message
news:JqSB4.9907$ds6.34742_at_afrodite.telenet-ops.be...
> Hi,
>
> i have to modify more than 600 logins.
> How to create a script to automatize it ?
>
> Best regards
>
> Gerard
>
>
Received on Wed Mar 22 2000 - 02:08:24 CET