Access Control List (ACL) Setup

An access control list (ACL), with respect to a computer file system, is a list of permissions attached to an object. An ACL specifies which users or system processes are granted access to objects, as well as what operations are allowed on given objects. Each entry in a typical ACLspecifies a subject and an operation.

https://en.wikipedia.org/wiki/Access_control_list

begin

  dbms_network_acl_admin.create_acl (
  acl          => 'networkacl.xml',
  description  => 'Allow Network Connectivity',
  principal    => 'PUBLIC',
  is_grant     => TRUE,
  privilege    => 'connect',
  start_date   => SYSTIMESTAMP,
  end_date     => NULL);

 dbms_network_acl_admin.assign_acl (
  acl         => 'networkacl.xml',
  host        => '127.0.0.1', --(web-service)
  lower_port  => '77', --lower port
  upper_port  => '9999'); --upper port
  commit;

end;