Oracle ACL

New security rules on Oracle 11g predicate that one must setup an ACL (Access Control List) to access outside websites. To to this, follow the following setup scripts:


BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'utl_http.xml',
description => 'http access',
principal => 'YOUR_SCHEMA',
is_grant => TRUE,
privilege => 'connect');
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
acl => 'utl_http.xml', 
principal => 'YOUR_SCHEMA',
is_grant => TRUE, 
privilege => 'connect',
position => null);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => 'utl_http_mlee.xml', 
host => 'your_hostname');
COMMIT;
END;
/