概述

今天主要介绍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.

常用脚本：

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;

二、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;