necessary privileges for loading java into Oracle 8.1.7.0.0 Enterprise database under WinNT 
Author Message
 necessary privileges for loading java into Oracle 8.1.7.0.0 Enterprise database under WinNT

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



Sat, 26 Mar 2005 16:54:03 GMT
 necessary privileges for loading java into Oracle 8.1.7.0.0 Enterprise database under WinNT

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.


Quote:
> 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.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



Sat, 26 Mar 2005 17:15:29 GMT
 necessary privileges for loading java into Oracle 8.1.7.0.0 Enterprise database under WinNT
Try Javasyspriv, Javadebugpriv and javauserpriv
regards
Srivenu


Sun, 27 Mar 2005 12:52:19 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Load Java Classes into Oracle Database

2. Enterprise report development with Oracle 8.0.4 / HP-UX and WinNT/ CTD

3. Are indexes necessary for staging tables to load to AS2000

4. 8.0.5 Enterprise using Win ME , Oracle loads for Win95 w/no DB Capabilities, Help

5. ---JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA---

6. Loading Java Objects from Database

7. Loading Java src into database

8. Loading Java Objects from Database

9. Enterprise Manager stops responding when I access privileges

10. sql server (regular) installed on winnt enterprise?

11. Can't install SQL Server 7.0 Enterprise edition on WinNT 4.0 sp 6


 
Powered by phpBB® Forum Software