VIEW: SYS.USER_RULE_SETS

Source

View Text - Preformatted

SELECT /*+ all_rows */ o.name, bu.name, bo.name, r.rs_comment
FROM   rule_set$ r, obj$ o, obj$ bo, user$ bu
WHERE  r.obj# = o.obj# and o.owner# = USERENV('SCHEMAID')
       and r.ectx# = bo.obj#(+) and bo.owner# = bu.user#(+)

View Text - HTML Formatted

SELECT /*+ ALL_ROWS */ O.NAME
, BU.NAME
, BO.NAME
, R.RS_COMMENT FROM RULE_SET$ R
, OBJ$ O
, OBJ$ BO
, USER$ BU WHERE R.OBJ# = O.OBJ#
AND O.OWNER# = USERENV('SCHEMAID')
AND R.ECTX# = BO.OBJ#(+)
AND BO.OWNER# = BU.USER#(+)