select t.owner_num, t.obj_num, t.ts_name
from sys.ku$_tts_view t
where (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (t.owner_num,0) OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT T.OWNER_NUM
, T.OBJ_NUM
, T.TS_NAME
FROM SYS.KU$_TTS_VIEW T
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (T.OWNER_NUM
, 0) OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|