不为人知的Oracle11g network_acl网络访问控制列表

主要介绍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;