Re: create user help

You can run the following script to create the empty user accounts. It will not grant permissions, but will create the account and the password for the users. You will want to move your roles over also and then apply them to the user accounts.

You will save the output of the scripts below to create the new accounts.

set heading off;
set linesize 140;
set pagesize 50;

select 'create user '||username||' identified by VALUES '''||password||''';'
from dba_users;

 select 'grant connect to '||username||';' from dba_users;

Good Luck
mreeves

On Mon, 05 Feb 2001 22:30:49 GMT, 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:16 CST