select OWNER, NAME, TYPE, LINE, TEXT, ORIGIN_CON_ID
from INT$DBA_SOURCE
where
(
OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
or
OWNER='PUBLIC'
or
(
(
(
(TYPE# in (7 /* proc */, 8 /* func */, 9 /* pkg */, 13 /* type */,
22 /* library */, 87 /* assembly */ ))
and
OBJ_ID(OWNER, NAME, TYPE#, OBJECT_ID) in
(select obj# from sys.objauth$
where grantee# in (select kzsrorol from x$kzsro)
and privilege# in (12 /* EXECUTE */, 26 /* DEBUG */))
)
or
(
(TYPE# in (11 /* package body */, 14 /* type body */))
and
exists
(
select null
from sys."_ACTUAL_EDITION_OBJ" specobj,
sys.dependency$ dep, sys.objauth$ oa, sys.user$ u
where u.name = INT$DBA_SOURCE.OWNER
and specobj.owner# = u.user#
and specobj.name = INT$DBA_SOURCE.NAME
and specobj.type# = decode(INT$DBA_SOURCE.TYPE#,
11 /* pkg body */, 9 /* pkg */,
14 /* type body */, 13 /* type */,
null)
and dep.d_obj# = OBJ_ID(INT$DBA_SOURCE.OWNER,
INT$DBA_SOURCE.NAME,
INT$DBA_SOURCE.TYPE#,
INT$DBA_SOURCE.OBJECT_ID)
and dep.p_obj# = specobj.obj#
and oa.obj# = specobj.obj#
and oa.grantee# in (select kzsrorol from x$kzsro)
and oa.privilege# = 26 /* DEBUG */)
)
or
(
(TYPE# = 12 /* trigger */)
and
exists
(
select null from sys.trigger$ t, sys.objauth$ oa
where bitand(t.property, 24) = 0
and t.obj# = OBJ_ID(INT$DBA_SOURCE.OWNER,
INT$DBA_SOURCE.NAME, 12,
INT$DBA_SOURCE.OBJECT_ID)
and oa.obj# = t.baseobject
and oa.grantee# in (select kzsrorol from x$kzsro)
and oa.privilege# = 26 /* DEBUG */)
)
or
exists
(
select null from sys.sysauth$
where grantee# in (select kzsrorol from x$kzsro)
and
(
(
/* procedure */
(TYPE# = 7 or TYPE# = 8 or TYPE# = 9)
and
(
privilege# = -144 /* EXECUTE ANY PROCEDURE */
or
privilege# = -141 /* CREATE ANY PROCEDURE */
or
privilege# = -241 /* DEBUG ANY PROCEDURE */
)
)
or
(
/* package body */
TYPE# = 11 and
(
privilege# = -141 /* CREATE ANY PROCEDURE */
or
privilege# = -241 /* DEBUG ANY PROCEDURE */
)
)
or
(
/* type */
TYPE# = 13
and
(
privilege# = -184 /* EXECUTE ANY TYPE */
or
privilege# = -181 /* CREATE ANY TYPE */
or
privilege# = -241 /* DEBUG ANY PROCEDURE */
)
)
or
(
/* type body */
TYPE# = 14 and
(
privilege# = -181 /* CREATE ANY TYPE */
or
privilege# = -241 /* DEBUG ANY PROCEDURE */
)
)
or
(
/* triggers */
TYPE# = 12 and
(
privilege# = -152 /* CREATE ANY TRIGGER */
or
privilege# = -241 /* DEBUG ANY PROCEDURE */
)
)
or
(
/* library */
TYPE# = 22 and
(
privilege# = -192 /* EXECUTE ANY LIBRARY */
or
privilege# = -189 /* CREATE ANY LIBRARY */
)
)
or
(
/* assembly */
TYPE# = 87 and
(
privilege# = -285 /* EXECUTE ANY ASSEMBLY */
or
privilege# = -282 /* CREATE ANY ASSEMBLY */
)
)
)
)
)
)
or
(
TYPE# = 28
and
(
(
OBJ_ID(OWNER, NAME, 28, OBJECT_ID) in (select obj# from sys.objauth$
where grantee# in (select kzsrorol from x$kzsro)
and privilege# in (12 /* EXECUTE */, 26 /* DEBUG */))
)
or
exists
(
select null from sys.sysauth$
where grantee# in (select kzsrorol from x$kzsro)
and
(
(
/* procedure */
(
privilege# = -144 /* EXECUTE ANY PROCEDURE */
or
privilege# = -141 /* CREATE ANY PROCEDURE */
or
privilege# = -241 /* DEBUG ANY PROCEDURE */
)
)
)
)
)
)
)
SELECT OWNER
, NAME
, TYPE
, LINE
, TEXT
, ORIGIN_CON_ID
FROM INT$DBA_SOURCE
WHERE
(
OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')
OR
OWNER='PUBLIC'
OR
(
(
(
(TYPE# IN (7 /* PROC */
, 8 /* FUNC */
, 9 /* PKG */
, 13 /* TYPE */
,
22 /* LIBRARY */
, 87 /* ASSEMBLY */ ))
AND
OBJ_ID(OWNER
, NAME
, TYPE#
, OBJECT_ID) IN
(SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND PRIVILEGE# IN (12 /* EXECUTE */
, 26 /* DEBUG */))
)
OR
(
(TYPE# IN (11 /* PACKAGE BODY */
, 14 /* TYPE BODY */))
AND
EXISTS
(
SELECT NULL
FROM SYS."_ACTUAL_EDITION_OBJ" SPECOBJ
,
SYS.DEPENDENCY$ DEP
, SYS.OBJAUTH$ OA
, SYS.USER$ U
WHERE U.NAME = INT$DBA_SOURCE.OWNER
AND SPECOBJ.OWNER# = U.USER#
AND SPECOBJ.NAME = INT$DBA_SOURCE.NAME
AND SPECOBJ.TYPE# = DECODE(INT$DBA_SOURCE.TYPE#
,
11 /* PKG BODY */
, 9 /* PKG */
,
14 /* TYPE BODY */
, 13 /* TYPE */
,
NULL)
AND DEP.D_OBJ# = OBJ_ID(INT$DBA_SOURCE.OWNER
,
INT$DBA_SOURCE.NAME
,
INT$DBA_SOURCE.TYPE#
,
INT$DBA_SOURCE.OBJECT_ID)
AND DEP.P_OBJ# = SPECOBJ.OBJ#
AND OA.OBJ# = SPECOBJ.OBJ#
AND OA.GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND OA.PRIVILEGE# = 26 /* DEBUG */)
)
OR
(
(TYPE# = 12 /* TRIGGER */)
AND
EXISTS
(
SELECT NULL
FROM SYS.TRIGGER$ T
, SYS.OBJAUTH$ OA
WHERE BITAND(T.PROPERTY
, 24) = 0
AND T.OBJ# = OBJ_ID(INT$DBA_SOURCE.OWNER
,
INT$DBA_SOURCE.NAME
, 12
,
INT$DBA_SOURCE.OBJECT_ID)
AND OA.OBJ# = T.BASEOBJECT
AND OA.GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND OA.PRIVILEGE# = 26 /* DEBUG */)
)
OR
EXISTS
(
SELECT NULL
FROM SYS.SYSAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND
(
(
/* PROCEDURE */
(TYPE# = 7 OR TYPE# = 8 OR TYPE# = 9)
AND
(
PRIVILEGE# = -144 /* EXECUTE ANY PROCEDURE */
OR
PRIVILEGE# = -141 /* CREATE ANY PROCEDURE */
OR
PRIVILEGE# = -241 /* DEBUG ANY PROCEDURE */
)
)
OR
(
/* PACKAGE BODY */
TYPE# = 11 AND
(
PRIVILEGE# = -141 /* CREATE ANY PROCEDURE */
OR
PRIVILEGE# = -241 /* DEBUG ANY PROCEDURE */
)
)
OR
(
/* TYPE */
TYPE# = 13
AND
(
PRIVILEGE# = -184 /* EXECUTE ANY TYPE */
OR
PRIVILEGE# = -181 /* CREATE ANY TYPE */
OR
PRIVILEGE# = -241 /* DEBUG ANY PROCEDURE */
)
)
OR
(
/* TYPE BODY */
TYPE# = 14 AND
(
PRIVILEGE# = -181 /* CREATE ANY TYPE */
OR
PRIVILEGE# = -241 /* DEBUG ANY PROCEDURE */
)
)
OR
(
/* TRIGGERS */
TYPE# = 12 AND
(
PRIVILEGE# = -152 /* CREATE ANY TRIGGER */
OR
PRIVILEGE# = -241 /* DEBUG ANY PROCEDURE */
)
)
OR
(
/* LIBRARY */
TYPE# = 22 AND
(
PRIVILEGE# = -192 /* EXECUTE ANY LIBRARY */
OR
PRIVILEGE# = -189 /* CREATE ANY LIBRARY */
)
)
OR
(
/* ASSEMBLY */
TYPE# = 87 AND
(
PRIVILEGE# = -285 /* EXECUTE ANY ASSEMBLY */
OR
PRIVILEGE# = -282 /* CREATE ANY ASSEMBLY */
)
)
)
)
)
)
OR
(
TYPE# = 28
AND
(
(
OBJ_ID(OWNER
, NAME
, 28
, OBJECT_ID) IN (SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND PRIVILEGE# IN (12 /* EXECUTE */
, 26 /* DEBUG */))
)
OR
EXISTS
(
SELECT NULL
FROM SYS.SYSAUTH$
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)
AND
(
(
/* PROCEDURE */
(
PRIVILEGE# = -144 /* EXECUTE ANY PROCEDURE */
OR
PRIVILEGE# = -141 /* CREATE ANY PROCEDURE */
OR
PRIVILEGE# = -241 /* DEBUG ANY PROCEDURE */
)
)
)
)
)
)
)
|
|
|