3 Replies Latest reply on Oct 27, 2014 7:13 AM by madhu G

    i didnt get any mail from oracle 11g using java with user login but same will work with sysdba

    madhu G

      i have created a procedure to send mail using java in oracle 11g,

      It works fine when connect as a sysdba,it sends mail successfully,,,

      But when i logged in as user(ex ori),everything goes on successfully but,i not getting any mail,

      i hope this is due to lack of priviliges.these are the priviliges i have granted

      execute dbms_java.grant_permission( 'ORI', 'SYS:java.lang.RuntimePermission', 'getClassLoader', '' );

      execute dbms_java.grant_permission( 'ORI', 'SYS:oracle.aurora.security.JServerPermission', 'Verifier', '' );

      execute dbms_java.grant_permission( 'ORI', 'SYS:java.lang.RuntimePermission', 'accessClassInPackage.sun.util.calendar', '' ) ;

      execute dbms_java.grant_permission( 'ORI', 'SYS:java.net.SocketPermission', 'localhost', 'resolve' );


      execute dbms_java.grant_permission( 'ORI', 'SYS:java.net.SocketPermission', '192.168.100.18', 'connect,resolve' );

      execute dbms_java.grant_permission( 'ORI', 'SYS:java.lang.RuntimePermission', 'createClassLoader', ' ');

      please help me out ....