DBA Data[Home] [Help]

VIEW: SYS.DBA_WALLET_ACLS

Source

View Text - Preformatted

select w.wallet_path, nvl(nm.xname, o.name), sys_xsid_to_raw(w.acl#),
       o.owner
  from sys.nacl$_wallet w, dba_xs_objects o, sys.nacl$_name_map nm
 where w.acl# = o.id (+) and o.id = nm.acl# (+)
View Text - HTML Formatted

SELECT W.WALLET_PATH
, NVL(NM.XNAME
, O.NAME)
, SYS_XSID_TO_RAW(W.ACL#)
, O.OWNER
FROM SYS.NACL$_WALLET W
, DBA_XS_OBJECTS O
, SYS.NACL$_NAME_MAP NM
WHERE W.ACL# = O.ID (+)
AND O.ID = NM.ACL# (+)