VIEW: SYS.ALL_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, sys.user$ u, dba_role_privs rp
  where ((xp.username = u.name) and  (u.user# = userenv('SCHEMAID')))
union
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, sys.user$ u, dba_role_privs rp
  where (u.name = rp.grantee
        and rp.granted_role = 'SELECT_CATALOG_ROLE'
        and (u.user# = userenv('SCHEMAID'))))

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
, SYS.USER$ U
, DBA_ROLE_PRIVS RP
WHERE ((XP.USERNAME = U.NAME)
AND (U.USER# = USERENV('SCHEMAID'))) UNION 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
, SYS.USER$ U
, DBA_ROLE_PRIVS RP
WHERE (U.NAME = RP.GRANTEE
AND RP.GRANTED_ROLE = 'SELECT_CATALOG_ROLE'
AND (U.USER# = USERENV('SCHEMAID'))))