VIEW: SYS.USER_REPSCHEMA

Source

View Text - Preformatted

select r.sname, r.dblink, r.masterdef, r.snapmaster, r.master_comment, r.sname,
       r.master, r.gowner
from repcat_repschema 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.DBLINK
, R.MASTERDEF
, R.SNAPMASTER
, R.MASTER_COMMENT
, R.SNAME
, R.MASTER
, R.GOWNER FROM REPCAT_REPSCHEMA R
, USER_USERS U WHERE (R.SNAME = U.USERNAME) OR R.GOWNER IN (SELECT NAME
FROM USER$
WHERE USER# = USERENV('SCHEMAID')
AND TYPE# = 1)