REM
REM Copyright (c) 2001, 2003, Oracle Corporation.  All rights reserved.  
REM
REM    NAME
REM      cwm2dgrt.sql
REM
REM    DESCRIPTION
REM      Creates all the necessary grants for the
REM      CWM2 union dba read api views 
REM
REM    NOTES
REM
REM    MODIFIED   (MM/DD/YY)
REM       dbardwel 09/19/03 - 
REM       dbardwel 09/10/03 - 
REM       dbardwel 06/01/03 - 
REM       mstasiew 05/15/03 - 
REM       glyon    12/31/02 - backport of mstasiew_txn105532
REM       dbardwel 01/04/02 - dbardwel_txn101266
REM     dbardwel    01/03/02  created.
REM     mstasiew    01/31/02  mstasiew_txn101768
REM     mstasiew    02/01/02  mstasiew_txn101798


grant select on olapsys.dba$olap2ucubes to select_catalog_role;
grant select on olapsys.dba$olap2ucube_measures to select_catalog_role;
grant select on olapsys.dba$olap2ucube_dim_uses to select_catalog_role;
grant select on olapsys.dba$olap2ucube_meas_dim_uses to select_catalog_role;
grant select on olapsys.dba$olap2udimensions to select_catalog_role;
grant select on olapsys.dba$olap2udim_hierarchies to select_catalog_role;
grant select on olapsys.dba$olap2udim_levels to select_catalog_role;
grant select on olapsys.dba$olap2udim_hier_level_uses to select_catalog_role;
grant select on olapsys.dba$olap2udim_attributes to select_catalog_role;
grant select on olapsys.dba$olap2udim_attr_uses to select_catalog_role;
grant select on olapsys.dba$olap2udim_level_attributes to select_catalog_role;
grant select on olapsys.dba$olap2ucube_measure_maps to select_catalog_role;
grant select on olapsys.dba$olap2ufact_level_uses to select_catalog_role;
grant select on olapsys.dba$olap2ujoin_key_column_uses to select_catalog_role;
grant select on olapsys.dba$olap2ulevel_key_col_uses to select_catalog_role;
grant select on olapsys.dba$olap2udim_level_attr_maps to select_catalog_role;
grant select on olapsys.dba$olap2ucatalogs to select_catalog_role;
grant select on olapsys.dba$olap2uentity_desc_uses to select_catalog_role;
grant select on olapsys.dba$olap2ucatalog_entity_uses to select_catalog_role;
grant select on olapsys.dba$olap2ufact_table_gid to select_catalog_role;
grant select on olapsys.dba$olap2uhier_custom_sort to select_catalog_role;
grant select on olapsys.dba$olapmr_FactTblKeyMaps to select_catalog_role;
grant select on olapsys.dba$olapmr_FactTblfctMaps to select_catalog_role;
grant select on olapsys.dba$olap2ulistdims to select_catalog_role;
grant select on olapsys.dba$olap2udim_hiers to select_catalog_role;
grant select on olapsys.dba$olap2uhierdims to select_catalog_role;
grant select on olapsys.dba$olap2_facttblkeymaps to select_catalog_role;
grant select on olapsys.dba$olap2_rufcttblkymaps to select_catalog_role;
grant select on olapsys.dba$olap2_FactTblFctMaps to select_catalog_role;
grant select on olapsys.dba$olap2uhierdim_keycol_map to select_catalog_role;
grant select on olapsys.dba$olapmr_dim_levels_keymaps to select_catalog_role;
grant select on olapsys.dba$olap2_dim_levels_keymaps to select_catalog_role;
grant select on olapsys.dba$olap2_mr_measdimview to select_catalog_role;
grant select on olapsys.dba$olap9i1_hier_dimensions to select_catalog_role;
grant select on olapsys.dba$olap9i2_hier_dimensions to select_catalog_role;
grant select on olapsys.dba$olap1_cubes to select_catalog_role;
grant select on olapsys.dba$olap2_awviews to select_catalog_role;
grant select on olapsys.dba$olap2_awviewcols to select_catalog_role;
grant select on olapsys.dba$olap2_aggregation_uses to select_catalog_role;
grant select on olapsys.dba$olap2uentity_parameters to select_catalog_role;
grant select on olapsys.dba$olap2uentity_ext_parms to select_catalog_role;