Rem
Rem $Header: cwm2mrag.sql 06-nov-2007.12:07:52 glyon Exp $
Rem
Rem cwm2mrav.sql
Rem
Rem Copyright (c) 2002, 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2mrav.sql - script contains view for performance enhanced
Rem                     metadata reader views
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       11/06/07 - bug 6596816: replace grant all with needed privs
Rem    glyon       06/04/07 - replace public with cwm_user in grant
Rem    dbardwel    06/25/03 - dbardwel_txn107256
Rem    dbardwel    05/05/03 - dbardwel_txn107026
Rem    mstasiew    04/15/03 - 
Rem    mstasiew    04/14/03 - mstasiew_txn106951
Rem    mstasiew    04/14/03 - 
Rem

grant select on olapsys.MRAC_OLAP2_AWS_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_MAP_DIM_USE_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_PHYS_OBJ_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_PHYS_OBJ_PROP_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_MAP_MEAS_USE_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_MAP_ATTR_USE_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_DIMENSIONS_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_ATTRIBUTES_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_CUBES_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_CUBE_DIM_USES_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_DIM_LEVELS_V to CWM_USER 
/
grant select on olapsys.MRAC_OLAP2_AW_CUBE_MEASURES_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_CUBE_AGG_SPECS_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_CUBE_AGG_MEAS_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_CUBE_AGG_LVL_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_CUBE_AGG_OP_V to CWM_USER
/
grant select on olapsys.MRAC_OLAP2_AW_HIER_LVL_ORD_V to CWM_USER
/