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
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
|
|
|