UTL_HTTP && Network ACL 11g

SELECT host, acl,

DECODE(

DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, 'VOLUME', 'resolve'),

1, 'GRANTED', 0, 'DENIED', NULL) privilege

FROM dba_network_acls;

SELECT host, lower_port, upper_port, acl,

DECODE(

DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, 'VOLUME', 'connect'),

1, 'GRANTED', 0, 'DENIED', null) privilege

FROM dba_network_acls;

SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES;

SELECT * FROM DBA_NETWORK_ACLS;

begin

dbms_network_acl_admin.assign_acl( 'volume_utl_http.xml', '*.com');

end;

begin

dbms_network_acl_admin.create_acl (

acl => 'volume_utl_http.xml',

description => 'HTTP Access',

principal => 'VOLUME',

is_grant => TRUE,

privilege => 'connect',

start_date => null,

end_date => null

);

dbms_network_acl_admin.add_privilege (

acl => 'volume_utl_http.xml',

principal => 'VOLUME',

is_grant => TRUE,

privilege => 'resolve',

start_date => null,

end_date => null

);

dbms_network_acl_admin.assign_acl( 'volume_utl_http.xml', '*.com');

commit;

end;