如何将新主机添加到现有Oracle ACL？

I cannot find what command to use to add a host to an existent ACL on Oralce. Let's assume my ACL is called users.xml, how can I add host "remote.host.net" ? Notice I'm on Oracle 11gR2

我找不到用于在Oralce上将主机添加到现有ACL的命令。我们假设我的ACL名为users.xml，如何添加主机“remote.host.net”？请注意我在Oracle 11gR2上

1 个解决方案

#1

I believe what you what you'd want to do is this:

我相信你想做的是这个：

BEGIN
   DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
    acl          => 'users.xml',                
    host         => 'remote.host.net',
    lower_port   => <whatever>,
    upper_port   => <whatever>);
   COMMIT;
END;
/