VIEW: SYS.KU$_REFGROUP_VIEW

Source

View Text - Preformatted

select  '1','0', r.name, u.user#, r.owner, r.refgroup,
          sys.dbms_metadata_util.get_refresh_make_user (r.refgroup),
          sys.dbms_metadata_util.get_refresh_make_dba (r.refgroup),
          cast(multiset(select value(s) from ku$_add_snap_view s
             where s.refgroup =r.refgroup)
                as ku$_add_snap_list_t
          )
  from sys.user$ u, sys.rgroup$  r
  where  u.name=r.owner
        AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (r.owner, 0) OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, R.NAME
, U.USER#
, R.OWNER
, R.REFGROUP
, SYS.DBMS_METADATA_UTIL.GET_REFRESH_MAKE_USER (R.REFGROUP)
, SYS.DBMS_METADATA_UTIL.GET_REFRESH_MAKE_DBA (R.REFGROUP)
, CAST(MULTISET(SELECT VALUE(S)
FROM KU$_ADD_SNAP_VIEW S
WHERE S.REFGROUP =R.REFGROUP) AS KU$_ADD_SNAP_LIST_T )
FROM SYS.USER$ U
, SYS.RGROUP$ R
WHERE U.NAME=R.OWNER
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (R.OWNER
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))