SELECT /*+ all_rows */
u.name, o.name, ru.name, ro.name,
decode(bitand(rm.property, 1), 1, 'DISABLED', 'ENABLED'),
eu.name, eo.name, rm.rm_comment
FROM rule_map$ rm, obj$ o, user$ u, obj$ ro, user$ ru, obj$ eo, user$ eu
WHERE rm.rs_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 (
-251, /* create any rule set */
-252, /* alter any rule set */
-253, /* drop any rule set */
-254 /* execute any rule set */))) and
o.owner# = u.user# and rm.r_obj# = ro.obj# and ro.owner# = ru.user#
and rm.ectx# = eo.obj#(+) and eo.owner# = eu.user#(+)
SELECT /*+ ALL_ROWS */
U.NAME
, O.NAME
, RU.NAME
, RO.NAME
,
DECODE(BITAND(RM.PROPERTY
, 1)
, 1
, 'DISABLED'
, 'ENABLED')
,
EU.NAME
, EO.NAME
, RM.RM_COMMENT
FROM RULE_MAP$ RM
, OBJ$ O
, USER$ U
, OBJ$ RO
, USER$ RU
, OBJ$ EO
, USER$ EU
WHERE RM.RS_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 (
-251
, /* CREATE ANY RULE SET */
-252
, /* ALTER ANY RULE SET */
-253
, /* DROP ANY RULE SET */
-254 /* EXECUTE ANY RULE SET */))) AND
O.OWNER# = U.USER#
AND RM.R_OBJ# = RO.OBJ#
AND RO.OWNER# = RU.USER#
AND RM.ECTX# = EO.OBJ#(+)
AND EO.OWNER# = EU.USER#(+)
|
|
|