VIEW: SYS.DBA_NETWORK_ACL_PRIVILEGES

Source

View Text - Preformatted

select nvl(nm.xname, ace.acl), sys_xsid_to_raw(o.id),
       ace.principal,
       decode(ace.privilege,
              'RESOLVE', 'resolve',
              'CONNECT', 'connect',
              'USE_CLIENT_CERTIFICATES', 'use-client-certificates',
              'USE_PASSWORDS', 'use-passwords',
              'HTTP', 'http',
              'HTTP_PROXY', 'http-proxy',
              'SMTP', 'smtp', ace.privilege),
       decode(ace.grant_type, 'GRANT', 'true', 'DENY', 'false'),
       decode(ace.inverted_principal, 'YES', 'true', 'NO', 'false'),
       ace.start_date, ace.end_date, o.owner
  from dba_xs_aces ace, dba_xs_objects o, sys.nacl$_name_map nm
 where ace.acl = o.name and ace.owner = o.owner and
       o.id in (select acl# from sys.nacl$_host) and o.id = nm.acl# (+)

View Text - HTML Formatted

SELECT NVL(NM.XNAME
, ACE.ACL)
, SYS_XSID_TO_RAW(O.ID)
, ACE.PRINCIPAL
, DECODE(ACE.PRIVILEGE
, 'RESOLVE'
, 'RESOLVE'
, 'CONNECT'
, 'CONNECT'
, 'USE_CLIENT_CERTIFICATES'
, 'USE-CLIENT-CERTIFICATES'
, 'USE_PASSWORDS'
, 'USE-PASSWORDS'
, 'HTTP'
, 'HTTP'
, 'HTTP_PROXY'
, 'HTTP-PROXY'
, 'SMTP'
, 'SMTP'
, ACE.PRIVILEGE)
, DECODE(ACE.GRANT_TYPE
, 'GRANT'
, 'TRUE'
, 'DENY'
, 'FALSE')
, DECODE(ACE.INVERTED_PRINCIPAL
, 'YES'
, 'TRUE'
, 'NO'
, 'FALSE')
, ACE.START_DATE
, ACE.END_DATE
, O.OWNER
FROM DBA_XS_ACES ACE
, DBA_XS_OBJECTS O
, SYS.NACL$_NAME_MAP NM
WHERE ACE.ACL = O.NAME
AND ACE.OWNER = O.OWNER AND O.ID IN (SELECT ACL#
FROM SYS.NACL$_HOST)
AND O.ID = NM.ACL# (+)