OraFAQ Forum: JDeveloper, Java & XML » exception - security manager - sending email using java stored procedure

Home » Developer & Programmer » JDeveloper, Java & XML » exception - security manager - sending email using java stored procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exception - security manager - sending email using java stored procedure [message #90936]

Wed, 12 December 2001 18:19

kumar tsn
Messages: 1
Registered: December 2001

Junior Member

Hi All,
Could you plz help me by solving this.????
I have written a java stored procedure to send email using smtp. While executing, is giving the following exception.
java.lang.SecurityException
at oracle.aurora.rdbms.SecurityManagerImpl.checkRole(SecurityManagerImpl.java)
at
oracle.aurora.rdbms.SecurityManagerImpl.checkConnect(SecurityManagerImpl.java)
at java.net.InetAddress.getAllByName0(InetAddress.java)
at java.net.InetAddress.getByName(InetAddress.java)
at java.net.Socket.<init>(Socket.java)
at sendMail.email(sendMail:36)

could you plz help me to solve this...most urgent...
thanks

----------------------------------------------------------------------

Report message to a moderator

Re: exception - security manager - sending email using java stored procedure [message #90995 is a reply to message #90936]

Fri, 01 February 2002 03:37

Euan Dean
Messages: 1
Registered: February 2002

Junior Member

-- These grants must be run for the Schema owner as sys changing schema to the name of the schema in which your java stored procedure will run

begin
sys.dbms_java.grant_permission('Schema','SYS:java.net.SocketPermission','smtp.jcom.net', 'resolve');
grant javasyspriv to 'Schema';
end;

Report message to a moderator