今天主要介紹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;
覺得有用的朋友多幫忙轉發哦！後面會分享更多devops和DBA方面的内容，感興趣的朋友可以關注下~
更多精彩资讯请关注tft每日頭條，我们将持续为您更新最新资讯!
zpostcode 
Recruit 
weather 
mreligion 
Yellowpages 
sport 
constellation 
shopping 
name 
game 
directory 
literature 
Word 
tour 
furnish 
Lottery 
tftnews 
lyrics 
News 
digital 
car 
dir 
Edu 
Finance 
