SELECT /*+ all_rows */
u.name, o.name, r.condition, bu.name, bo.name, r.r_action, r.r_comment
FROM rule$ r, obj$ o, user$ u, obj$ bo, user$ bu
WHERE r.obj# = o.obj# and
(o.owner# in (USERENV('SCHEMAID'), 1 /* PUBLIC */) or
o.obj# in (select oa.obj# from sys.objauth$ oa
where grantee# in (select kzsrorol from x$kzsro)) or
exists (select null from v$enabledprivs where priv_number in (
-258, /* create any rule */
-259, /* alter any rule */
-260, /* drop any rule */
-261 /* execute any rule set */))) and
o.owner# = u.user# and r.ectx# = bo.obj#(+) and bo.owner# = bu.user#(+)
SELECT /*+ ALL_ROWS */
U.NAME
, O.NAME
, R.CONDITION
, BU.NAME
, BO.NAME
, R.R_ACTION
, R.R_COMMENT
FROM RULE$ R
, OBJ$ O
, USER$ U
, OBJ$ BO
, USER$ BU
WHERE R.OBJ# = O.OBJ# AND
(O.OWNER# IN (USERENV('SCHEMAID')
, 1 /* PUBLIC */) OR
O.OBJ# IN (SELECT OA.OBJ#
FROM SYS.OBJAUTH$ OA
WHERE GRANTEE# IN (SELECT KZSROROL
FROM X$KZSRO)) OR
EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (
-258
, /* CREATE ANY RULE */
-259
, /* ALTER ANY RULE */
-260
, /* DROP ANY RULE */
-261 /* EXECUTE ANY RULE SET */))) AND
O.OWNER# = U.USER#
AND R.ECTX# = BO.OBJ#(+)
AND BO.OWNER# = BU.USER#(+)
|
|
|