VIEW: SYS.KU$_TABPROP_VIEW

Source

View Text - Preformatted

select o.obj#, o.name, u.name, o.flags, t.property
 from obj$ o, user$ u, tab$ t
 where o.owner# = u.user#
 and   o.obj#   = t.obj#
 and  (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner#,0) OR
                EXISTS ( SELECT * FROM sys.session_roles
                        WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT O.OBJ#
, O.NAME
, U.NAME
, O.FLAGS
, T.PROPERTY
FROM OBJ$ O
, USER$ U
, TAB$ T
WHERE O.OWNER# = U.USER#
AND O.OBJ# = T.OBJ#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))