今天主要介绍Oracle11g 网络访问控制列表--DBA_NETWORK_ACL。
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 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;