Re: How do you insert new users in Oracle applications:
From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 19 Feb 2004 09:13:56 +0100
Message-ID: <c11rdv$1b99ri$1_at_ID-93924.news.uni-berlin.de>
Date: Thu, 19 Feb 2004 09:13:56 +0100
Message-ID: <c11rdv$1b99ri$1_at_ID-93924.news.uni-berlin.de>
[Quoted] "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,
[Quoted] 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 Received on Thu Feb 19 2004 - 09:13:56 CET