开启Oracle ACL权限
执行以下语句
BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => ‘open_acl_file.xml‘,
description => ‘Open ACL File‘,
principal => ‘目标Oracle账号‘,
is_grant => TRUE,
privilege => ‘connect‘,
start_date => SYSTIMESTAMP,
end_date => NULL);
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => ‘open_acl_file.xml‘,
host => ‘*‘,
lower_port => 1,
upper_port => 9999);
COMMIT;
END;
/
这个权限比较大:因为host是*,端口不限。在正式使用时,可以缩小权限。比如第二段改成:
dbms_network_acl_admin.assign_acl(acl => ‘open_acl_file.xml‘,
host=> ‘ 具体IP地址 ‘,
lower_port => 8080,
upper_port => 8080);
END