VIEW: SYS.DBA_STREAMS_ADMINISTRATOR

Source

View Text - Preformatted

select u.name, decode(bitand(pu.privs, 1), 0, 'NO', 'YES'),
       decode(bitand(pu.privs, 2), 0, 'NO', 'YES')
  from user$ u, "_DBA_STREAMS_PRIVILEGED_USER" pu
 where u.user# = pu.user# AND pu.privs != 0 and
       (pu.flags IS NULL or pu.flags = 0 or (bitand(pu.flags, 1) = 1))

View Text - HTML Formatted

SELECT U.NAME
, DECODE(BITAND(PU.PRIVS
, 1)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(PU.PRIVS
, 2)
, 0
, 'NO'
, 'YES')
FROM USER$ U
, "_DBA_STREAMS_PRIVILEGED_USER" PU
WHERE U.USER# = PU.USER#
AND PU.PRIVS != 0 AND (PU.FLAGS IS NULL OR PU.FLAGS = 0 OR (BITAND(PU.FLAGS
, 1) = 1))