VIEW: SYS.ALL_REPGROUP_PRIVILEGES

Source

View Text - Preformatted

select u.username, rp.gname, rp.created,
       decode(bitand(rp.privilege, 1), 1, 'Y', 'N'),
       decode(bitand(rp.privilege, 2), 2, 'Y', 'N'),
       rp.gowner
from  system.repcat$_repgroup_privs rp, all_users u
where rp.username = u.username
  and u.user_id = userenv('SCHEMAID')
  and (rp.userid > 0 OR rp.userid IS NULL)

View Text - HTML Formatted

SELECT U.USERNAME
, RP.GNAME
, RP.CREATED
, DECODE(BITAND(RP.PRIVILEGE
, 1)
, 1
, 'Y'
, 'N')
, DECODE(BITAND(RP.PRIVILEGE
, 2)
, 2
, 'Y'
, 'N')
, RP.GOWNER FROM SYSTEM.REPCAT$_REPGROUP_PRIVS RP
, ALL_USERS U WHERE RP.USERNAME = U.USERNAME
AND U.USER_ID = USERENV('SCHEMAID')
AND (RP.USERID > 0 OR RP.USERID IS NULL)