select '1','0',
o.obj_num,
value(o),
p.class,
p.prepost,
o.type_num,
p.level#,
p.package,
p.schema,
sys.dbms_metadata.get_procobj
( p.package, p.schema,'CREATE_EXP', o.obj_num,
(select 1 from dual
where (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
OR EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))))
from sys.ku$_schemaobj_view o, sys.exppkgobj$ p
where p.type#=o.type_num and
(p.class=1 or p.class=2) 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'
,
O.OBJ_NUM
,
VALUE(O)
,
P.CLASS
,
P.PREPOST
,
O.TYPE_NUM
,
P.LEVEL#
,
P.PACKAGE
,
P.SCHEMA
,
SYS.DBMS_METADATA.GET_PROCOBJ
( P.PACKAGE
, P.SCHEMA
, 'CREATE_EXP'
, O.OBJ_NUM
,
(SELECT 1
FROM DUAL
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0
OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))))
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.EXPPKGOBJ$ P
WHERE P.TYPE#=O.TYPE_NUM AND
(P.CLASS=1 OR P.CLASS=2) AND
(SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR
EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|