Re: User Management in Oracle

> Hello everyone,

I am using Oracle 9i on W2k server. If I have to create dozen or two dozen 
users, what is the best option? Do I have to create each user separetly, 
assign him a role and profile or is there a short cut.

If all the users have the same privileges then is it possible to create 
them 
in a group form.

Regards,

Amir

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus

You could write a procedure that creates a user with the standard roles 
and privileges etc and call that for each user:

SQL> exec create_a_user('FRED');

PL/SQL procedure successfully completed.

SQL> exec create_a_user('BILL');

PL/SQL procedure successfully completed.

...etc.

The procedure would have to use EXECUTE IMMEDIATE to do the CREATE USER 
etc. commands.
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].