DBA Data[Home] [Help]

VIEW: SYS.DBA_WALLET_ACES

Source

View Text - Preformatted

select w.wallet_path,
       ace.ace_order, ace.start_date, ace.end_date,
       ace.grant_type, ace.inverted_principal,
       ace.principal, ace.principal_type, ace.privilege
  from sys.nacl$_wallet w, dba_xs_objects o, dba_xs_aces ace
 where w.acl# = o.id and o.owner = ace.owner and o.name = ace.acl
View Text - HTML Formatted

SELECT W.WALLET_PATH
, ACE.ACE_ORDER
, ACE.START_DATE
, ACE.END_DATE
, ACE.GRANT_TYPE
, ACE.INVERTED_PRINCIPAL
, ACE.PRINCIPAL
, ACE.PRINCIPAL_TYPE
, ACE.PRIVILEGE
FROM SYS.NACL$_WALLET W
, DBA_XS_OBJECTS O
, DBA_XS_ACES ACE
WHERE W.ACL# = O.ID
AND O.OWNER = ACE.OWNER
AND O.NAME = ACE.ACL