In your job, which tool do you use to insert 1000 new users in Oracle applications ?

Thanks

"Shiva MahaDeva" <contracer11 (AT) uol (DOT) com.br> schrieb im Newsbeitrag
news:ddf392ea.0402182009.2f98b073 (AT) posting (DOT) google.com...
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

"Jan Gelbrich" <j_gelbrich (AT) westfalen-blatt (DOT) de> wrote

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

- mcs