Oracle-L: RE: help

From: Eberhard, Jeff <Jeff.Eberhard_at_Rolls-RoyceGS.com>
Date: Tue, 08 Apr 2003 12:23:43 -0800
Message-ID: <F001.0057D44D.20030408122343@fatcity.com>

Plus another note. Maybe try replacing the 'connect,resolve' in the grant_permission to 'accept,connect,listen,resolve'

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