VIEW: SYS.ALL_MEASURE_FOLDERS

Source

View Text - Preformatted

SELECT
  u.name OWNER,
  o.name MEASURE_FOLDER_NAME,
  mf.obj# MEASURE_FOLDER_ID,
  d.description_value DESCRIPTION
FROM
  olap_measure_folders$ mf,
  obj$ o,
  user$ u,
  (select d.* from olap_descriptions$ d, nls_session_parameters n where
        n.parameter = 'NLS_LANGUAGE'
        and d.description_type = 'Description'
        and d.owning_object_type = 10 --MEASURE_FOLDER
        and (d.language = n.value
             or d.language like n.value || '\_%' escape '\')) d
WHERE
  mf.obj# = o.obj#
  AND o.owner# = u.user#
  AND mf.obj# = d.owning_object_id(+)
  AND (o.owner# in (userenv('SCHEMAID'), 1)   -- public objects
       or o.obj# in
            ( select obj#  -- directly granted privileges
              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 (-316, -- DELETE ANY MEASURE FOLDER
                                              -317, -- DROP ANY MEASURE FOLDER
                                              -318, -- INSERT ANY MEASURE FOLDER
                                              -393, -- SELECT ANY MEASURE FOLDER
                                              -394) -- ALTER ANY MEASURE FOLDER
                        )
              )
            )

View Text - HTML Formatted

SELECT U.NAME OWNER
, O.NAME MEASURE_FOLDER_NAME
, MF.OBJ# MEASURE_FOLDER_ID
, D.DESCRIPTION_VALUE DESCRIPTION FROM OLAP_MEASURE_FOLDERS$ MF
, OBJ$ O
, USER$ U
, (SELECT D.*
FROM OLAP_DESCRIPTIONS$ D
, NLS_SESSION_PARAMETERS N WHERE N.PARAMETER = 'NLS_LANGUAGE'
AND D.DESCRIPTION_TYPE = 'DESCRIPTION'
AND D.OWNING_OBJECT_TYPE = 10 --MEASURE_FOLDER
AND (D.LANGUAGE = N.VALUE OR D.LANGUAGE LIKE N.VALUE || '\_%' ESCAPE '\')) D WHERE MF.OBJ# = O.OBJ#
AND O.OWNER# = U.USER#
AND MF.OBJ# = D.OWNING_OBJECT_ID(+)
AND (O.OWNER# IN (USERENV('SCHEMAID')
, 1) -- PUBLIC OBJECTS OR O.OBJ# IN ( SELECT OBJ# -- DIRECTLY GRANTED PRIVILEGES
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 (-316
, -- DELETE ANY MEASURE FOLDER -317
, -- DROP ANY MEASURE FOLDER -318
, -- INSERT ANY MEASURE FOLDER -393
, -- SELECT ANY MEASURE FOLDER -394) -- ALTER ANY MEASURE FOLDER ) ) )