begin
begin
dbms_network_acl_admin.drop_acl (acl => ‘all-network-PUBLIC.xml’);
xyz
abc def
ghi
null;
end;
dbms_network_acl_admin.create_acl
(acl => ‘all-network-PUBLIC.xml’
, description => ‘Network connects for all’
, principal => ‘PUBLIC’
, is_grant => true
, privilege => ‘connect’
);
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE
(acl => ‘all-network-PUBLIC.xml’
, principal => ‘PUBLIC’
, is_grant => true
, privilege => ‘

dbms_network_acl_admin.assign_acl (acl => ‘all-network-PUBLIC.xml’, host => ‘*’);
end;
/
commit;