开启OracleACL权限

执行以下语句

BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => &＃39;open_acl_file.xml&＃39;, 
    description  => &＃39;Open ACL File&＃39;,
    principal    => &＃39;目标Oracle账号&＃39;,
    is_grant     => TRUE, 
    privilege    => &＃39;connect&＃39;,
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);

  DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => &＃39;open_acl_file.xml&＃39;,
    host        => &＃39;*&＃39;, 
    lower_port  => 1,
    upper_port  => 9999); 

  COMMIT;
END;
/

这个权限比较大：因为host是*，端口不限。在正式使用时，可以缩小权限。比如第二段改成：

dbms_network_acl_admin.assign_acl(acl => &＃39;open_acl_file.xml&＃39;,
    host=> &＃39; 具体IP地址 &＃39;,
    lower_port => 8080,
    upper_port => 8080);
END