VIEW: SYS.DBA_XS_ROLES

Source

View Text - Preformatted

select o.name, p.guid, p.ext_src, decode(p.enable, 0, 'NO', 1, 'YES'),
       p.start_date, p.end_date, p.description
  from sys.xs$prin p, sys.xs$obj o
 where o.id = p.prin# and p.type = 1

View Text - HTML Formatted

SELECT O.NAME
, P.GUID
, P.EXT_SRC
, DECODE(P.ENABLE
, 0
, 'NO'
, 1
, 'YES')
, P.START_DATE
, P.END_DATE
, P.DESCRIPTION
FROM SYS.XS$PRIN P
, SYS.XS$OBJ O
WHERE O.ID = P.PRIN#
AND P.TYPE = 1