Forum Stats

  • 3,757,025 Users
  • 2,251,186 Discussions
  • 7,869,693 Comments

Discussions

ACL error in Oracle Apex 5 after schema change

Su.gi
Su.gi Member Posts: 511
edited Oct 13, 2015 3:09AM in APEX Discussions

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

Tagged:

Best Answer

Answers

This discussion has been closed.