VIEW: SYS.KU$_POST_DATA_TABLE_VIEW

Source

View Text - Preformatted

select '1','1',
         t.obj#, value(o),
         t.spare1
  from sys.ku$_schemaobj_view o, sys.tab$ t
  where t.obj#=o.obj_num and
        bitand(t.spare1,32768)!=0 and
        bitand(t.trigflag,1048576)=0 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 '1'
, '1'
, T.OBJ#
, VALUE(O)
, T.SPARE1
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.TAB$ T
WHERE T.OBJ#=O.OBJ_NUM AND BITAND(T.SPARE1
, 32768)!=0 AND BITAND(T.TRIGFLAG
, 1048576)=0 AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))