Newsgroups: comp.databases.oracle.misc
Subject: Re: Adding Users
References: <32ED346D.2781E494@cc.uq.oz.au>

Priya Tantry  writes:

>What is the best way of adding users to Oracle in bulk on Unix?

>Priya

Priya,

The answer to this question will depend on what type of privileges you wish
to assign to the users. If you want to categorize the users, use ROLES. This
way, you assign all privileges once to the role, then simply assign the users
you add to those roles.

To add users in bulk, I usually write a SQL script that allows the passing of
a parameter, such as:
____________________________________________________________________
create user &username identified by &passwd;
grant connect to &&username;
{follow with all other appropriate grants here}
____________________________________________________________________

You can then run the script and type in the username and password...

Hope this helps.


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: www.arikaplan.com                          <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page to Ari Kaplan's Home Page