DBMS_NETWORK_ACL_ADMIN to public

begin
 DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'DPB.xml',
    description  => ' ACL functionality',
    principal => 'DPB',
    is_grant     => TRUE,
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);

   DBMS_NETWORK_ACL_ADMIN.assign_acl (
      acl         => 'DPB.xml',
      host        => '*',
      lower_port  => 1,
    upper_port  => 9999);


  DBMS_NETWORK_ACL_ADMIN.assign_acl (
     acl         => 'DPB.xml',
     host        => '*.dpbrep.com',
     lower_port  => null,
     upper_port  => null);

 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/DPB.xml','DPB', TRUE, 'connect');
 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/DPB.xml','DPB', TRUE, 'resolve');
 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/DPB.xml','PUBLIC', TRUE, 'resolve');
 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/DPB.xml','PUBLIC', TRUE, 'connect');

commit;
end;