VIEW: SYS.DBA_XS_ACLS

Source

View Text - Preformatted

select o1.name, o1.owner, o2.name, o2.owner, o3.name, o3.owner,
       decode(a.acl_flag,1,'EXTENDED',2,'CONSTRAINED','NONE'), a.description
  from sys.xs$obj o1, sys.xs$obj o2, sys.xs$obj o3, sys.xs$acl a
 where o1.id = a.acl# and o2.id(+) = a.sc# and o3.id(+) = a.parent_acl#

View Text - HTML Formatted

SELECT O1.NAME
, O1.OWNER
, O2.NAME
, O2.OWNER
, O3.NAME
, O3.OWNER
, DECODE(A.ACL_FLAG
, 1
, 'EXTENDED'
, 2
, 'CONSTRAINED'
, 'NONE')
, A.DESCRIPTION
FROM SYS.XS$OBJ O1
, SYS.XS$OBJ O2
, SYS.XS$OBJ O3
, SYS.XS$ACL A
WHERE O1.ID = A.ACL#
AND O2.ID(+) = A.SC#
AND O3.ID(+) = A.PARENT_ACL#