VIEW: SYS.DBA_XS_OBJECTS

Source

View Text - Preformatted

select name, owner, id,
       decode(type, 1, 'PRINCIPAL',
                    2, 'SECURITY CLASS',
                    3, 'ACL',
                    4, 'PRIVILEGE',
                    5, 'DATA SECURITY',
                    7, 'NAMESPACE TEMPLATE'),
       decode(status, 0, 'INVALID', 1, 'VALID', 2, 'EXTERNAL')
  from sys.xs$obj where type in (1, 2, 3, 4, 5, 7)

View Text - HTML Formatted

SELECT NAME
, OWNER
, ID
, DECODE(TYPE
, 1
, 'PRINCIPAL'
, 2
, 'SECURITY CLASS'
, 3
, 'ACL'
, 4
, 'PRIVILEGE'
, 5
, 'DATA SECURITY'
, 7
, 'NAMESPACE TEMPLATE')
, DECODE(STATUS
, 0
, 'INVALID'
, 1
, 'VALID'
, 2
, 'EXTERNAL')
FROM SYS.XS$OBJ
WHERE TYPE IN (1
, 2
, 3
, 4
, 5
, 7)