select t.obj#, 'T',
bitand(t.property, 4294967295),
trunc(t.property / power(2, 32)),
t.ts#,
value(o), value(o)
from ku$_schemaobj_view o, sys.tab$ t
where o.obj_num=t.obj#
AND bitand(t.property,8192)=0 /* is not a nested table */
AND o.status != 5 /* table is not invalid/unauthorized */
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' ))
SELECT T.OBJ#
, 'T'
,
BITAND(T.PROPERTY
, 4294967295)
,
TRUNC(T.PROPERTY / POWER(2
, 32))
,
T.TS#
,
VALUE(O)
, VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
, SYS.TAB$ T
WHERE O.OBJ_NUM=T.OBJ#
AND BITAND(T.PROPERTY
, 8192)=0 /* IS NOT A NESTED TABLE */
AND O.STATUS != 5 /* TABLE IS NOT INVALID/UNAUTHORIZED */
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' ))
|
|
|