概述

今天主要介绍Oracle11g 网络访问控制列表--DBA_NETWORK_ACL。

一、DBA_NETWORK_ACL_PRIVILEGES

DBA_NETWORK_ACL_PRIVILEGES describes the network privileges defined in all access control lists that are currently assigned to network hosts.

oracle11g服务器配置（一文看懂Oracle11g网络访问控制列表和常用脚本）(1)

常用脚本：

Description : Displays privileges for the network ACLs.

SET LINESIZE 1000 COLUMN acl FORMAT A50 COLUMN principal FORMAT A20 COLUMN privilege FORMAT A10 col IS_GRANT for a20 ​ ​ SELECT acl, principal, privilege, is_grant, TO_CHAR(start_date, 'DD-MON-YYYY') AS start_date, TO_CHAR(end_date, 'DD-MON-YYYY') AS end_date FROM dba_network_acl_privileges ORDER BY acl, principal, privilege;

oracle11g服务器配置（一文看懂Oracle11g网络访问控制列表和常用脚本）(2)

二、DBA_NETWORK_ACLS

DBA_NETWORK_ACLS describes the access control list assignments to network hosts.

常用命令：

Description : Displays information about network ACLs.

SELECT host, lower_port, upper_port, acl FROM dba_network_acls ORDER BY host;

oracle11g服务器配置（一文看懂Oracle11g网络访问控制列表和常用脚本）(3)

觉得有用的朋友多帮忙转发哦！后面会分享更多devops和DBA方面的内容，感兴趣的朋友可以关注下~

oracle11g服务器配置（一文看懂Oracle11g网络访问控制列表和常用脚本）(4)

,