11G ACL CONTROL LIST CONFIGURE

1.

begin
dbms_network_acl_admin.create_acl (
acl             => 'utlcontrol.xml',
description     => 'Normal Access',
principal       => 'CONNECT',
is_grant        => TRUE,
privilege       => 'connect',
start_date      => null,
end_date        => null
        );
end;

2.

begin
dbms_network_acl_admin.add_privilege (
acl        => 'utlcontrol.xml',
principal    => 'XHL',
is_grant    => TRUE,
privilege    => 'connect',
start_date    => null,
end_date    => null);
end;

3.

begin
dbms_network_acl_admin.assign_acl (
acl => 'utlcontrol.xml',
host => '10.133.130.61',
lower_port => 22,
upper_port => 55);
end;

4.

select host, lower_port, upper_port, acl, aclid
from dba_network_acls
where ACL='/sys/acls/utlcontrol.xml';

 

SELECT * FROM DBA_NETWORK_ACL_PRIVILEGES

请使用浏览器的分享功能分享到微信等