Re: How do you insert new users in Oracle applications:

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:c11rdv$1b99ri$1_at_ID-93924.news.uni-berlin.de...
| "Shiva MahaDeva" <contracer11_at_uol.com.br> schrieb im Newsbeitrag
| news:ddf392ea.0402182009.2f98b073_at_posting.google.com...
| > In your job, which tool do you use to insert 1000 new users in Oracle
| applications ?
| >
| > Thanks
|
| If all of the users with only a few different privilige profiles - write
an
| SQL-script,
| using a simple text editor; IMHO still the easiest method to do it.
| And then run it in SQLPlus.
|
| If everybody should have an "individual" set of priviliges, do it one by
| one.
| But that is hard work and a bad idea in the first place, because
| so many different sets are hard to maintain - and they make no sense.
|
| hth, Jan
|
|

remember to make sure you are using roles to grant privileges -- avoid directly granting any system or object privileges to application users

• mcs