VIEW: SYS.ALL_SNAPSHOTS

Source

View Text - Preformatted

select s."OWNER",s."NAME",s."TABLE_NAME",s."MASTER_VIEW",s."MASTER_OWNER",s."MASTER",s."MASTER_LINK",s."CAN_USE_LOG",s."UPDATABLE",s."REFRESH_METHOD",s."LAST_REFRESH",s."ERROR",s."FR_OPERATIONS",s."CR_OPERATIONS",s."TYPE",s."NEXT",s."START_WITH",s."REFRESH_GROUP",s."UPDATE_TRIG",s."UPDATE_LOG",s."QUERY",s."MASTER_ROLLBACK_SEG",s."STATUS",s."REFRESH_MODE",s."PREBUILT" from dba_snapshots s, sys.obj$ o, sys.user$ u
where o.owner#     = u.user#
  and s.table_name = o.name
  and u.name       = s.owner
  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."OWNER"
, S."NAME"
, S."TABLE_NAME"
, S."MASTER_VIEW"
, S."MASTER_OWNER"
, S."MASTER"
, S."MASTER_LINK"
, S."CAN_USE_LOG"
, S."UPDATABLE"
, S."REFRESH_METHOD"
, S."LAST_REFRESH"
, S."ERROR"
, S."FR_OPERATIONS"
, S."CR_OPERATIONS"
, S."TYPE"
, S."NEXT"
, S."START_WITH"
, S."REFRESH_GROUP"
, S."UPDATE_TRIG"
, S."UPDATE_LOG"
, S."QUERY"
, S."MASTER_ROLLBACK_SEG"
, S."STATUS"
, S."REFRESH_MODE"
, S."PREBUILT"
FROM DBA_SNAPSHOTS S
, SYS.OBJ$ O
, SYS.USER$ U WHERE O.OWNER# = U.USER#
AND S.TABLE_NAME = O.NAME
AND U.NAME = S.OWNER
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 */) ) )