VIEW: SYS.USER_HOST_ACES

Source

View Text - Preformatted

select host, lower_port, upper_port, privilege,
       decode(status, 0, 'DENIED', 1, 'GRANTED', null)
  from (select h.host, h.lower_port, h.upper_port, xo.name privilege,
               sys_check_privilege(sys_xsid_to_raw(xo.id), h.acl#, null) status
          from sys.nacl$_host h, dba_xs_objects xo
         where xo.owner = 'SYS'
           and xo.name in ('RESOLVE', 'CONNECT', 'HTTP', 'HTTP_PROXY', 'SMTP')
           and xo.type = 'PRIVILEGE')
 where status in (0, 1)

View Text - HTML Formatted

SELECT HOST
, LOWER_PORT
, UPPER_PORT
, PRIVILEGE
, DECODE(STATUS
, 0
, 'DENIED'
, 1
, 'GRANTED'
, NULL)
FROM (SELECT H.HOST
, H.LOWER_PORT
, H.UPPER_PORT
, XO.NAME PRIVILEGE
, SYS_CHECK_PRIVILEGE(SYS_XSID_TO_RAW(XO.ID)
, H.ACL#
, NULL) STATUS
FROM SYS.NACL$_HOST H
, DBA_XS_OBJECTS XO
WHERE XO.OWNER = 'SYS'
AND XO.NAME IN ('RESOLVE'
, 'CONNECT'
, 'HTTP'
, 'HTTP_PROXY'
, 'SMTP')
AND XO.TYPE = 'PRIVILEGE')
WHERE STATUS IN (0
, 1)