What kind of error are you getting when loading a class as a user with
CREATE PROCEDURE and CREATE TABLE privs only? (And I suppose
the user also has CREATE SESSION as it is necessary for the user to be
able to connect to the db.)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"David" <dfairman16_at_hotmail.com> wrote in message
news:b4cefdce.0210080054.64b13aa3_at_posting.google.com...
> Hi, I'm attempting to load some Java stored procedures into an Oracle
> database with loadjava. The command I am using in a DOS box is:
>
> loadjava -f -verbose -user testuser/testuser_at_dbtest
>
> This works well when I grant all privs and all roles to user testuser.
> However I don't want to grant all privs, I only want to grant the
> necessary privs.
>
> So what are the necessary privs?
>
> According to the Oracle docs
>
> http://www.znow.com/sales/oracle/java.816/a81358/02_load3.htm
>
> the privs I need to grant to testuser are CREATE PROCEDURE and CREATE
> TABLE
>
> but this is not enough. Ideas anyone.
>
> Thank you
> David
Received on Tue Oct 08 2002 - 04:15:29 CDT
