VIEW: SYS.DBA_NETWORK_ACLS

Source

View Text - Preformatted

select h.host, h.lower_port, h.upper_port, nvl(nm.xname, o.name),
       sys_xsid_to_raw(h.acl#), o.owner
  from sys.nacl$_host h, dba_xs_objects o, sys.nacl$_name_map nm
 where h.acl# = o.id (+) and o.id = nm.acl# (+)

View Text - HTML Formatted

SELECT H.HOST
, H.LOWER_PORT
, H.UPPER_PORT
, NVL(NM.XNAME
, O.NAME)
, SYS_XSID_TO_RAW(H.ACL#)
, O.OWNER
FROM SYS.NACL$_HOST H
, DBA_XS_OBJECTS O
, SYS.NACL$_NAME_MAP NM
WHERE H.ACL# = O.ID (+)
AND O.ID = NM.ACL# (+)