VIEW: SYS.KU$_SEQ_IN_DEFAULT_VIEW

Source

View Text - Preformatted

select unique c.obj#
 from sys.obj$ o, sys.col$ c
 where bitand(trunc(c.property / power(2,32)),8) != 0
 and o.obj#=c.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 UNIQUE C.OBJ#
FROM SYS.OBJ$ O
, SYS.COL$ C
WHERE BITAND(TRUNC(C.PROPERTY / POWER(2
, 32))
, 8) != 0
AND O.OBJ#=C.OBJ#
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER#
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))