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:

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.***.com/

the privs I need to grant to testuser are CREATE PROCEDURE and CREATE
TABLE

but this is not enough. Ideas anyone.

Thank you
David

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.)

--

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.

Try Javasyspriv, Javadebugpriv and javauserpriv
regards
Srivenu