Working with ACL
As sys USER:
----------------
exec DBMS_NETWORK_ACL_ADMIN.CREATE_ACL
(
acl=> 'EBIS.xml',
description => 'ACL for Test Purpose',
principal=> 'TESTADM',
is_grant=> true,
privilege =>'connect'
);
exec DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'Test.xml', host => '192.168.9.4');
select * from dba_network_acls;
select * from dba_network_acl_privileges;
select * from user_network_acl_privileges;
SELECT DISTINCT aclid, XD.DESCRIPTION FROM xds_acl xd;
If you want to unassign an host from an ACL please execute below procedure
begin
DBMS_NETWORK_ACL_ADMIN.UNASSIGN_ACL(acl => 'Test.xml', host => '192.168.9.5');
end;
/
As a TESTADM USER:
-------------------
> select sys.utl_http.request('http://192.168.9.5') from dual;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-24247: network access denied by access control list...