Get ACL details in database - Oracle Database Script. SET lines 200 COL ACL_OWNER FOR A12 COL ACL FOR A67 COL HOST FOR A34 col PRINCIPAL FOR a20 col PRIVILEGE FOR a13 SELECT ACL_OWNER, ACL, HOST, LOWER_PORT, UPPER_PORT FROM dba_network_acls; SELECT ACL_OWNER, ACL, PRINCIPAL, PRIVILEGE FROM dba_network_acl_privileges;
SET lines 200 COL ACL_OWNER FOR A12 COL ACL FOR A67 COL HOST FOR A34 col PRINCIPAL FOR a20 col PRIVILEGE FOR a13 SELECT ACL_OWNER, ACL, HOST, LOWER_PORT, UPPER_PORT FROM dba_network_acls; SELECT ACL_OWNER, ACL, PRINCIPAL, PRIVILEGE FROM dba_network_acl_privileges;