VIEW: SYS.KU$_IND_TS_VIEW

Source

View Text - Preformatted

select i.owner_num, i.obj_num, i.ts_name
  from   sys.ku$_tts_ind_view i
  where  (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (i.owner_num,0) OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT I.OWNER_NUM
, I.OBJ_NUM
, I.TS_NAME
FROM SYS.KU$_TTS_IND_VIEW I
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (I.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))