Allow all hosts and ports using ACL
Posted: Thu May 22, 2025 2:48 am
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'ERPSTUFF'',
principal_type => xs_acl.ptype_db));
END;
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'ERPSTUFF'',
principal_type => xs_acl.ptype_db));
END;