Re: Entering Users Into Oracle

From: DET <none_at_i_hate_spammers.com>
Date: Tue, 4 Aug 1998 08:47:58 -0700
Message-ID: <6q7aao$m5a@netaxs.com>

### start unix shell script
#
# you must be logged in as oracle to use this
#####
# syntax is:
#
#    whatever_you_name_it_script username password
#
#####
# change the grants to whatever you use
#####
# change the password for system from "manager" to whatever you use, or make

it a command-line parameter.

# or you might be able to use "connect internal", depending on your setup.
#####
#

echo "

connect system/manager

create user $1 identified by $2

        default tablespace your_default_tablespace
        temporary tablespace temp;

grant CREATE SESSION to $1;
grant CREATE TABLE to $1;
grant UNLIMITED TABLESPACE to $1;
grant CREATE PUBLIC SYNONYM to $1;
grant DROP PUBLIC SYNONYM to $1;

" | svrmgrl
#
#### end shell script

Geraldine Grubb wrote in message <35C0DE1D.AE71FEE6_at_indiana.edu>...
>Hi,
>
>Can anyone tell me how to put a large number of users into Oracle. I
>have a text file list of users and I need to generate a script to add
>them to Oracle. Can this be done with PL/SQL? How? Or does anyone
>have a script for this that they have already written.
>
>You can reply to my email or the newsgroup.
>
>Geraldine Grubb
>ggrubb_at_indiana.edu
>812 855-5492
>
>
Received on Tue Aug 04 1998 - 10:47:58 CDT