VIEW: SYS.ALL_XDS_ACL_REFRESH

Source

View Text - Preformatted

select s.schema_name,
          s.table_name,
          s.acl_mview_name,
          s.refresh_mode,
          s.refresh_ability,
          s.acl_status,
          s.user_supplied_mv,
          s.start_date,
          s.repeat_interval,
          s.refresh_count,
          s.comments
from dba_xds_acl_refresh s, sys.obj$ o, sys.user$ u
where o.owner#     = u.user#
  and s.table_name = o.name
  and u.name       = s.schema_name
  and o.type#      = 2                     /* table */
  and ( u.user# in (userenv('SCHEMAID'), 1)
        or
        o.obj# in ( select obj#
                    from sys.objauth$
                    where grantee# in ( select kzsrorol
                                        from x$kzsro
                                      )
                  )
       or /* user has system privileges */
         exists (select null from v$enabledprivs
                 where priv_number in (-45 /* LOCK ANY TABLE */,
                                       -47 /* SELECT ANY TABLE */,
                                       -397/* READ ANY TABLE */,
                                       -48 /* INSERT ANY TABLE */,
                                       -49 /* UPDATE ANY TABLE */,
                                       -50 /* DELETE ANY TABLE */)
                 )
      )

View Text - HTML Formatted

SELECT S.SCHEMA_NAME
, S.TABLE_NAME
, S.ACL_MVIEW_NAME
, S.REFRESH_MODE
, S.REFRESH_ABILITY
, S.ACL_STATUS
, S.USER_SUPPLIED_MV
, S.START_DATE
, S.REPEAT_INTERVAL
, S.REFRESH_COUNT
, S.COMMENTS FROM DBA_XDS_ACL_REFRESH S
, SYS.OBJ$ O
, SYS.USER$ U WHERE O.OWNER# = U.USER#
AND S.TABLE_NAME = O.NAME
AND U.NAME = S.SCHEMA_NAME
AND O.TYPE# = 2 /* TABLE */
AND ( U.USER# IN (USERENV('SCHEMAID')
, 1) OR O.OBJ# IN ( SELECT OBJ#
FROM SYS.OBJAUTH$
WHERE GRANTEE# IN ( SELECT KZSROROL
FROM X$KZSRO ) ) OR /* USER HAS SYSTEM PRIVILEGES */ EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-45 /* LOCK ANY TABLE */
, -47 /* SELECT ANY TABLE */
, -397/* READ ANY TABLE */
, -48 /* INSERT ANY TABLE */
, -49 /* UPDATE ANY TABLE */
, -50 /* DELETE ANY TABLE */) ) )