Rem
Rem
Rem onemrdat.sql
Rem
Rem  Copyright (c) Oracle Corporation 2001. All Rights Reserved.
Rem
Rem    NAME
Rem      onemrdat.sql - all$olapmr_dim_attributes
Rem
Rem    DESCRIPTION
Rem      Dimension Attrbutes.
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       06/24/08 - bug 7204558: eliminate references to sys.user$
Rem    cdalessi    07/06/01 - cdalessi_t50006
Rem    ddedonat    05/29/01 - Created
Rem

CREATE OR REPLACE VIEW all$olapmr_dim_attributes AS SELECT
  u.username              owner, 
  o.name                  dimension_name,
  att.physicalname        attribute_name,
  att.displayname         display_name,
  att.description         description,
  ce.classification_irid  desc_id
FROM 
  dba_users               u,
  sys.obj$                o,
  cwm$dimensionattribute  att,
  cwm$classificationentry ce
WHERE o.type# = 43 AND
      u.user_id = o.owner# AND
      att.itemcontainer_irid = o.obj# AND
      att.irid = ce.element_irid(+) AND
      (   cwm$util.dimension_tables_visible(o.obj#) = 'Y'
          OR EXISTS
          /* SELECT ANY TABLE, CREATE, ALTER, DROP ANY DIMENSION */
          (SELECT null FROM v$enabledprivs 
           WHERE priv_number IN (-47,-215,-216,-217)))
WITH READ ONLY
/