General Assign a network host to Access Control List

admin 2016.06.07 09:51 Views : 203

BEGIN
   DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
    acl          => 'UTL_HTTP.xml',                
    host         => 'google.com');
   COMMIT;
END;
/

---------------------------------------.
BEGIN
   DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
    acl          => 'UTL_HTTP.xml',               
    host         => 'localhost',   
    lower_port => '1',
    upper_port => '10000');
   COMMIT;
END;
/