Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PUBLIC:Re: Bulk Loading Policies
Hi,
From my experience I agree with Eugen the account used for the insertion does not need DBA rights.
I don't know about the policy side of it but I use Perl scripts to call
SQL Loader and insert the data.
The user account only has select/insert access on the table (its owned
by another accoung). SQL Loader doesnt need select access (as far as I
can remember) but I do for debugging purposes.
Cheers,
Mark
Eugen Nyffeler wrote:
>
> JAL wrote:
> >
> > Hi all,
> > We have Oracle 7.3.3.4 on a Unix box, Solaris 2.5.1 and we will be
> > receiving data to upload into the production database, i.e. bank
> > reconciliation tapes. The data will be initially loaded into an
> > intermediate table before going into the database. We have been told that
> > in order for clients to do this they must have DBA rights, which I can't
> > believe, to use SQL Loader.
<snip>
Did you find it more
> > advantageous to have the client do the bulk loads or is this something that
> > should be done by the DBA?
> > Thanks in advance for your answers.
> >
> > --
> > Juanita R. Alvarez
> > Database Administration Team Lead
> > Pima Community College
> > 4905A E. Broadway
> > Tucson, AZ 85709
> > Email is jalvarez_at_tpimacc.pima.edu
>
<heavy snip>
>
> To my limited knowledge there's no reason why the client has to have DBA
> rights.
>
> rgds
> eugen
-- Mark Robbins All views and comments expressed above, are my own and not necessarily those of my employer. mark.robbins.nospam_at_ntc.nokia.com Remove .nospam to get my real email address.Received on Wed Feb 18 1998 - 00:00:00 CST