Re: create user help

From: Matt Gay <invisiblelizard_at_worldnet.att.net>
Date: Mon, 05 Feb 2001 23:06:40 GMT
Message-ID: <3A7F3281.B0E1BDC3@worldnet.att.net>

If you still have access to the original db, you could go in there and write some dynamic SQL to build your create user script. Something like this:

select 'create user '||username||' identified by {temporary password} default tablespace '||default_tablespace||' temporary tablespace '||temporary_tablespace||';'
from dba_users
where username not in ('SYSTEM','SYS');

Spool this to a file and run it on the new database before you import.

Matt

steve128_at_my-deja.com wrote:

> I would like to create hundreds of users, the same of an exported db
> and would like to know if there is a simple way to create it (execute
> it in sql).
>
> Your help is very appreciated.
>
> Steve
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Feb 05 2001 - 17:06:40 CST