VIEW: SYS.ALL_ZONEMAPS

Source

View Text - Preformatted

select z."OWNER",z."ZONEMAP_NAME",z."FACT_OWNER",z."FACT_TABLE",z."SCALE",z."HIERARCHICAL",z."WITH_CLUSTERING",z."QUERY",z."QUERY_LEN",z."PRUNING",z."REFRESH_MODE",z."REFRESH_METHOD",z."LAST_REFRESH_METHOD",z."LAST_REFRESH_TIME",z."INVALID",z."STALE",z."UNUSABLE",z."COMPILE_STATE" from dba_zonemaps z, sys.obj$ o, sys.user$ u
where o.owner#        = u.user#
  and z.zonemap_name  = o.name
  and u.name          = z.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 Z."OWNER"
, Z."ZONEMAP_NAME"
, Z."FACT_OWNER"
, Z."FACT_TABLE"
, Z."SCALE"
, Z."HIERARCHICAL"
, Z."WITH_CLUSTERING"
, Z."QUERY"
, Z."QUERY_LEN"
, Z."PRUNING"
, Z."REFRESH_MODE"
, Z."REFRESH_METHOD"
, Z."LAST_REFRESH_METHOD"
, Z."LAST_REFRESH_TIME"
, Z."INVALID"
, Z."STALE"
, Z."UNUSABLE"
, Z."COMPILE_STATE"
FROM DBA_ZONEMAPS Z
, SYS.OBJ$ O
, SYS.USER$ U WHERE O.OWNER# = U.USER#
AND Z.ZONEMAP_NAME = O.NAME
AND U.NAME = Z.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 */) ) )