VIEW: SYS.USER_REPGROUP

Source

View Text - Preformatted

select r.sname, r.master, r.status, r.schema_comment, r.sname, r.fname,
       r.rpc_processing_disabled, r.gowner
from repcat_repcat r, user_users u
where (r.sname = u.username)
   or r.gowner in
      (select name from user$
        where user# = userenv('SCHEMAID') and type# = 1)

View Text - HTML Formatted

SELECT R.SNAME
, R.MASTER
, R.STATUS
, R.SCHEMA_COMMENT
, R.SNAME
, R.FNAME
, R.RPC_PROCESSING_DISABLED
, R.GOWNER FROM REPCAT_REPCAT R
, USER_USERS U WHERE (R.SNAME = U.USERNAME) OR R.GOWNER IN (SELECT NAME
FROM USER$
WHERE USER# = USERENV('SCHEMAID')
AND TYPE# = 1)