select '1','0',
s.obj#, value(o),
s.increment$, TO_CHAR(s.minvalue), TO_CHAR(s.maxvalue),
s.cycle#, s.order$, s.cache,
TO_CHAR(s.highwater), replace(s.audit$,chr(0),'-'), s.flags,
s.partcount
from sys.ku$_schemaobj_view o, sys.seq$ s
where s.obj# = o.obj_num AND mod(nvl(s.flags,0), 64) < 32 AND
(SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '1'
, '0'
,
S.OBJ#
, VALUE(O)
,
S.INCREMENT$
, TO_CHAR(S.MINVALUE)
, TO_CHAR(S.MAXVALUE)
,
S.CYCLE#
, S.ORDER$
, S.CACHE
,
TO_CHAR(S.HIGHWATER)
, REPLACE(S.AUDIT$
, CHR(0)
, '-')
, S.FLAGS
,
S.PARTCOUNT
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.SEQ$ S
WHERE S.OBJ# = O.OBJ_NUM
AND MOD(NVL(S.FLAGS
, 0)
, 64) < 32 AND
(SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|