1 Reply Latest reply on Oct 13, 2015 7:09 AM by Kiran Pawar

    ACL error in Oracle Apex 5 after schema change

    Su.gi

      Hi All,

         I am creating an application using Oracle Apex 5.

      I have one button call Send Mail and mail is worked.

       

      Now i have imported my application in another schema and configured acl as below.  

       

      I am using apex_mail.send  for sending mail and created acl as

      BEGIN

      DBMS_NETWORK_ACL_ADMIN.drop_acl (

      acl          => 'open_apex.xml');

         DBMS_NETWORK_ACL_ADMIN.create_acl (

          acl          => 'open_apex.xml',

          description  => 'A test of the ACL functionality',

          principal    => 'RMSR',

          is_grant     => TRUE,

          privilege    => 'connect',

          start_date   => SYSTIMESTAMP,

          end_date     => NULL);

       

        DBMS_NETWORK_ACL_ADMIN.assign_acl (

          acl         => 'open_apex.xml',

          host        => '*',

          lower_port  => 20,

          upper_port  => 9999);

       

        COMMIT;

        end;

       

      BEGIN

        DBMS_NETWORK_ACL_ADMIN.add_privilege (

          acl         => 'open_apex.xml',

          principal   => 'RMSR',

          is_grant    => TRUE,

          privilege   => 'connect',

          position    => NULL,

          start_date  => NULL,

          end_date    => NULL);

        COMMIT;

      END;

       

       

      It throws error as

      ORA-24247: network access denied by access control list (ACL)

       

      Is there any problem in my configuration?

       

      Thanks in Advance,

      Su.gi