RE: help

Just catching up on emails so I don't know if anyone has answered this or if it is too late. I don't know anything about this but I went to a hands-on training a couple weeks ago on Java stored procedures. During the hands-on part we were getting a similar error but it didn't relate to socket permissions. The scary part was the error message told you what to do (I think SYS had to do the grant_permission).

Most likely you have tried it but I would log into SYS or SYSTEM and do:

execute dbms_java.grant_permission(
'PRADEEP','SYS:java.net.SocketPermission','129.168.9.128:3000',
'connect,resolve' )

Well nevermind, I just reread your message and noticed that you already did the grant. From my notes it mentions there are a couple Oracle roles (deprecated) which may exist: JAVAUSERPRIV and JAVASYSPRIV. Maybe for a test grant the JAVASYSPRIV to PRADEEP and see what happens.

--Jeff

-----Original Message-----
Sent: Wednesday, April 02, 2003 10:49 PM To: Multiple recipients of list ORACLE-L

Hi,

I have loaded a class to the database using loadjava. I have written a server which listens to a particular port(say 3000). The client class loaded to the database gathers infromation from the database and sends it to the server which needs to accept at port 3000.
Database is showing some information that grant needs to be given. I have loogedin Sys and given the grant also. Still not working.

SQL> exec SPR_DATETEST;
the Permission (java.net.SocketPermission 129.168.9.128:3000 connect,resolve)
has not been granted to PRADEEP. The PL/SQL to grant this is dbms_java.grant_permission( 'PRADEEP',
'SYS:java.net.SocketPermission',
'129.168.9.128:3000', 'connect,resolve' )

PL/SQL procedure successfully completed.

What will be problem. Can somebody help me ? When I tested the class outside the database, it is working fine.

Regards,
Pradeep

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: pradeep_at_ibsplc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Eberhard, Jeff
  INET: Jeff.Eberhard_at_Rolls-RoyceGS.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).