3 Replies Latest reply: Feb 28, 2013 4:41 AM by Rob_J RSS

    Email using UTL_MAIL

    700284
      I am trying to send an email from Oracle 11g r2 . When I try the following command ( as SYS) , it works fine .
      ( I logged in as SYS , just to test ....I understand it is not good practice) .

      But , as a non-SYS user , I get the following error ...


      ERROR at line 1:
      ORA-24247: network access denied by access control list (ACL)
      ORA-06512: at "SYS.UTL_MAIL", line 654
      ORA-06512: at "SYS.UTL_MAIL", line 671
      ORA-06512: at line 1

      The user has been granted execute privilges on the following packages .


      Grantor Table_Name Privilege Gra
      ------------------------------ ------------------------------ ---------------------------------------- ---
      SYS UTL_HTTP EXECUTE No
      SYS UTL_INADDR EXECUTE No
      SYS UTL_MAIL EXECUTE No
      SYS UTL_SMTP EXECUTE No
      SYS UTL_TCP EXECUTE No


      SQL> Select * from product_component_version;

      PRODUCT VERSION STATUS
      -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------
      NLSRTL 11.2.0.1.0 Production
      Oracle Database 11g Enterprise Edition 11.2.0.1.0 64bit Production
      PL/SQL 11.2.0.1.0 Production
      TNS for 64-bit Windows: 11.2.0.1.0 Production


      smtp is confiured correctly ( as the email works for SYS) .