In its broadest sense, learning can be defined as a process of
progressive change from ignorance to knowledge,
and from indifference to understanding....
11G ACL CONTROL LIST CONFIGURE
上一篇 /
下一篇 2008-06-25 17:22:42
/ 个人分类：Oracle
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
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
