正德厚生,臻于至善

EBS网络访问被访问控制列表(ACL)拒绝

BEGIN
  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl         => '/sys/acls/OracleEBS.xml',
                                    description => 'ACL FOR EBS',
                                    principal   => 'APPS',
                                    is_grant    => true,
                                    privilege   => 'connect',
                                    start_date  => null,
                                    end_date    => null );
  COMMIT;
END;
/

BEGIN
  DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl       => '/sys/acls/OracleEBS.xml',
                                       principal => 'APPS',
                                       is_grant  => true,
                                       privilege => 'resolve');
  COMMIT;
END;
/

BEGIN
   DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
                              acl        => '/sys/acls/OracleEBS.xml',
                              host       => '*',
                              lower_port => null,
                              upper_port => null);
   COMMIT;
END;
/
commit;

select * from dba_network_acls;
select utl_inaddr.get_host_address() from dual;
赞(0) 打赏
未经允许不得转载:徐万新之路 » EBS网络访问被访问控制列表(ACL)拒绝

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫

微信扫一扫

登录

找回密码

注册