ora-24247：网络访问被访问控制列表(ACL)拒绝

 用dba账户使用下面脚本授予报错账户访问外部网络服务的权限，以SCOTT为例：

 1 BEGIN
 2 
 3   -- Only uncomment the following line if ACL "network_services.xml" has already been created
 4   --DBMS_NETWORK_ACL_ADMIN.DROP_ACL('network_services.xml');
 5 
 6   DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
 7     acl => 'network_services.xml',
 8     description => 'NETWORK ACL',
 9     principal => 'SCOTT',
10     is_grant => true,
11     privilege => 'connect');
12 
13   DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(
14     acl => 'network_services.xml',
15     principal => 'SCOTT',
16     is_grant => true,
17     privilege => 'resolve');
18 
19   DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
20     acl => 'network_services.xml',
21     host => '*');
22 
23   COMMIT;
24 
25 END;

 

posted @ 2014-06-05 23:40  楪夕  阅读(1319)  评论(0)  编辑  收藏  举报