select '1','0',
null, d.obj#,
value(o),
p.package, p.schema, p.level#, p.class, pr.prepost,
null, null, null, null, null, null, null
FROM sys.ku$_schemaobj_view o,
sys.exppkgact$ p,
sys.expdepact$ d,
ku$_prepost_view pr
WHERE d.obj# = o.obj_num AND d.package = p.package
and d.schema = p.schema and p.class = 7
and (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0)
OR EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
ORDER by p.level#
SELECT '1'
, '0'
,
NULL
, D.OBJ#
,
VALUE(O)
,
P.PACKAGE
, P.SCHEMA
, P.LEVEL#
, P.CLASS
, PR.PREPOST
,
NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM SYS.KU$_SCHEMAOBJ_VIEW O
,
SYS.EXPPKGACT$ P
,
SYS.EXPDEPACT$ D
,
KU$_PREPOST_VIEW PR
WHERE D.OBJ# = O.OBJ_NUM
AND D.PACKAGE = P.PACKAGE
AND D.SCHEMA = P.SCHEMA
AND P.CLASS = 7
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0)
OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
ORDER BY P.LEVEL#
|
|
|