Re: script to create users like existing users

Paul,

thanks for your response.
[Quoted] I have to create new Oracle login to harmonize all logins ( NT, Mail, Unix, [Quoted] Oracle, ...) ; then i have to create new Oracle users with the same grants, [Quoted] roles, ... than the old logins, and thne remove the old login. One by one is [Quoted] a big work ... then i search the best way to create a script to automatize this migration.

Best regards

Gérard

"Paul Druker" <pdruker_at_metaway.com> a écrit dans le message news: c2VB4.773$h3.7525_at_typhoon.southeast.rr.com...
> Gerard,
>
> 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 - 21:46:40 CET