Search notes:

Oracle: DBA_NETWORK_ACLS

dba_network_acls Access control lists assigned to restrict access to network hosts through PL/SQL network utility packages utl_tcp, utl_http, utl_smtp and utl_inaddr.

select
  host,
  lower_port,
  upper_port,
  acl,
  aclid
from
  dba_network_acls;

Github repository Oracle-Patterns, path: /Installed/data-dictionary/network/acls/show.sql

select
  prv.principal,
  prv.privilege,
  acl.host,
  acl.lower_port,
  acl.upper_port,
--acl.acl,
  prv.is_grant,
  prv.invert,
  prv.start_date
from
  dba_network_acl_privileges  prv  join
  dba_network_acls            acl on prv.aclid = acl.aclid
order by
  prv.principal,
  prv.privilege;

Github repository Oracle-Patterns, path: /Installed/data-dictionary/network/acl_privileges/show.sql

Oracle: DBA_NETWORK_ACLS

See also