VIEW: SYS.DBA_XSTREAM_ADMINISTRATOR

Source

View Text - Preformatted

select xp.username,
       decode(xp.privilege_type, 1, 'CAPTURE',
                              2, 'APPLY',
                              3, '*'),
       decode(xp.privilege_level, 0, 'NO',
                               1, 'YES'),
       xp.create_time
  from sys.xstream$_privileges xp

View Text - HTML Formatted

SELECT XP.USERNAME
, DECODE(XP.PRIVILEGE_TYPE
, 1
, 'CAPTURE'
, 2
, 'APPLY'
, 3
, '*')
, DECODE(XP.PRIVILEGE_LEVEL
, 0
, 'NO'
, 1
, 'YES')
, XP.CREATE_TIME
FROM SYS.XSTREAM$_PRIVILEGES XP