VIEW: SYS.ALL_RULE_SETS

Source

View Text - Preformatted

SELECT /*+ all_rows */
       u.name, o.name, bu.name, bo.name, r.rs_comment
FROM   rule_set$ 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 (
                 -251, /* create any rule set */
                 -252, /* alter any rule set */
                 -253, /* drop any rule set */
                 -254  /* execute any rule set */))) and
       u.user# = o.owner# and
       r.ectx# = bo.obj#(+) and bo.owner# = bu.user#(+)

View Text - HTML Formatted

SELECT /*+ ALL_ROWS */ U.NAME
, O.NAME
, BU.NAME
, BO.NAME
, R.RS_COMMENT FROM RULE_SET$ 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 ( -251
, /* CREATE ANY RULE SET */ -252
, /* ALTER ANY RULE SET */ -253
, /* DROP ANY RULE SET */ -254 /* EXECUTE ANY RULE SET */))) AND U.USER# = O.OWNER# AND R.ECTX# = BO.OBJ#(+)
AND BO.OWNER# = BU.USER#(+)