BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
    acl => 'network_services.xml',
    description => 'IP_GATE',
    principal => 'IBS',
    is_grant => TRUE,
    privilege => 'connect');
  DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
    acl => 'network_services.xml',
    principal => 'IBS',
    is_grant => TRUE,
    privilege => 'resolve');
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
    acl => 'network_services.xml',
    host => '192.168.16.120',
    lower_port => 40080,
    upper_port => 40080);
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
    acl => 'network_services.xml',
    host => '127.0.0.1',
    lower_port => 40080,
    upper_port => 40080);
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
    acl => 'network_services.xml',
    host => '192.168.16.120',
    lower_port => 40080,
    upper_port => 40080);
  COMMIT;
END;




BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
    acl => 'mx0_services.xml',
    description => 'IP_GATE',
    principal => 'IBS',
    is_grant => TRUE,
    privilege => 'connect');
  DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
    acl => 'mx0_services.xml',
    principal => 'IBS',
    is_grant => TRUE,
    privilege => 'resolve');
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
    acl => 'mx0_services.xml',
    host => 'mx0.mpbbank.ru',
    lower_port => 25,
    upper_port => 25);
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
    acl => 'mx0_services.xml',
    host => 'mx0.mpbbank.ru',
    lower_port => 25,
    upper_port => 25);
  COMMIT;
END;