select '1','0',
null, null, null,
'DBMS_PLUGTS','SYS',
0,
102,
0,
null,null,
p1.prepost,p2.prepost,p3.prepost,p4.prepost,p5.prepost
from ku$_prepost_view p1, ku$_prepost_view p2, ku$_prepost_view p3,
ku$_prepost_view p4, ku$_prepost_view p5
where (SYS_CONTEXT('USERENV','CURRENT_USERID')=0
OR EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
SELECT '1'
, '0'
,
NULL
, NULL
, NULL
,
'DBMS_PLUGTS'
, 'SYS'
,
0
,
102
,
0
,
NULL
, NULL
,
P1.PREPOST
, P2.PREPOST
, P3.PREPOST
, P4.PREPOST
, P5.PREPOST
FROM KU$_PREPOST_VIEW P1
, KU$_PREPOST_VIEW P2
, KU$_PREPOST_VIEW P3
,
KU$_PREPOST_VIEW P4
, KU$_PREPOST_VIEW P5
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0
OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|