1.
begin
dbms_network_acl_admin.create_acl (
acl => 'utlcontrol.xml',
description => 'Normal Access',
principal => 'CONNECT',
is_grant => TRUE,
privilege => 'connect',
start_date => null,
end_date => null
);
end;
2.
begin
dbms_network_acl_admin.add_privilege (
acl => 'utlcontrol.xml',
principal => 'XHL',
is_grant => TRUE,
privilege => 'connect',
start_date => null,
end_date => null);
end;
3.
begin
dbms_network_acl_admin.assign_acl (
acl => 'utlcontrol.xml',
host => '10.133.130.61',
lower_port => 22,
upper_port => 55);
end;
4.
select host, lower_port, upper_port, acl, aclid
from dba_network_acls
where ACL='/sys/acls/utlcontrol.xml';
SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES