VIEW: SYS.KU$_2ND_TABLE_OBJNUM_VIEW

Source

View Text - Preformatted

select t.obj#, 'T',
         bitand(t.property, 4294967295),
         trunc(t.property / power(2, 32)),
         t.ts#,
         value(o), value(o2)
  from ku$_schemaobj_view o, ku$_schemaobj_view o2, secobj$ s, sys.tab$ t
  where o.obj_num=t.obj#
  AND s.secobj#=o.obj_num
  AND s.obj#=o2.obj_num
  AND bitand(t.property,8192)=0      /* is not a nested table */
  AND bitand(t.flags,536870912)=0    /* not an IOT mapping table */
  AND bitand(trunc(t.property/power(2,32)),2)=0 /* not FBA internal table */
  AND bitand(t.property,power(2,44))=0  /* not an ACLMV container table */
  AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0)
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT T.OBJ#
, 'T'
, BITAND(T.PROPERTY
, 4294967295)
, TRUNC(T.PROPERTY / POWER(2
, 32))
, T.TS#
, VALUE(O)
, VALUE(O2)
FROM KU$_SCHEMAOBJ_VIEW O
, KU$_SCHEMAOBJ_VIEW O2
, SECOBJ$ S
, SYS.TAB$ T
WHERE O.OBJ_NUM=T.OBJ#
AND S.SECOBJ#=O.OBJ_NUM
AND S.OBJ#=O2.OBJ_NUM
AND BITAND(T.PROPERTY
, 8192)=0 /* IS NOT A NESTED TABLE */
AND BITAND(T.FLAGS
, 536870912)=0 /* NOT AN IOT MAPPING TABLE */
AND BITAND(TRUNC(T.PROPERTY/POWER(2
, 32))
, 2)=0 /* NOT FBA INTERNAL TABLE */
AND BITAND(T.PROPERTY
, POWER(2
, 44))=0 /* NOT AN ACLMV CONTAINER TABLE */
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))