VIEW: SYS.ALL_REGISTERED_SNAPSHOTS

Source

View Text - Preformatted

select  "OWNER","NAME","SNAPSHOT_SITE","CAN_USE_LOG","UPDATABLE","REFRESH_METHOD","SNAPSHOT_ID","VERSION","QUERY_TXT" from dba_registered_snapshots s
where exists (select a.snapshot_id from  all_snapshot_logs a
                             where  s.snapshot_id = a.snapshot_id)
or  userenv('SCHEMAID') = 1
or  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 "OWNER"
, "NAME"
, "SNAPSHOT_SITE"
, "CAN_USE_LOG"
, "UPDATABLE"
, "REFRESH_METHOD"
, "SNAPSHOT_ID"
, "VERSION"
, "QUERY_TXT"
FROM DBA_REGISTERED_SNAPSHOTS S WHERE EXISTS (SELECT A.SNAPSHOT_ID
FROM ALL_SNAPSHOT_LOGS A
WHERE S.SNAPSHOT_ID = A.SNAPSHOT_ID) OR USERENV('SCHEMAID') = 1 OR 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 */) )