REM
REM Copyright (c) 2001, 2003, Oracle Corporation.  All rights reserved.  
REM
REM    NAME
REM      cwm2asyn.sql
REM
REM    DESCRIPTION
REM      Creates all the necessary public synonyms for the
REM      CWM2 union read api views as well as security
REM      permission checking.
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/29/02 - use create or replace form per Oracle recommedation
REM       dbardwel 01/24/02 - Removed drops and put them in cwm2drop.sql
REM       dbardwel 01/04/02 - dbardwel_txn101266
REM       awesley  11/07/01 - awesley_txn100634
REM      dbardwel  10/31/01  created
REM      mstasiew  11/20/01 - mstasiew_txn100734
REM     mstasiew    01/31/02  mstasiew_txn101768
 
REM      mstasiew  11/20/01 - mstasiew_txn100734
REM     mstasiew    02/01/02  mstasiew_txn101798 

create or replace public synonym dba_olap2_cubes for olapsys.dba$olap2ucubes;
create or replace public synonym dba_olap2_cube_measures for olapsys.dba$olap2ucube_measures;
create or replace public synonym dba_olap2_cube_dim_uses for olapsys.dba$olap2ucube_dim_uses;
create or replace public synonym dba_olap2_cube_meas_dim_uses for olapsys.dba$olap2ucube_meas_dim_uses;
create or replace public synonym dba_olap2_dimensions for olapsys.dba$olap2udimensions;
create or replace public synonym dba_olap2_dim_hierarchies for olapsys.dba$olap2udim_hierarchies;
create or replace public synonym dba_olap2_dim_levels for olapsys.dba$olap2udim_levels;
create or replace public synonym dba_olap2_dim_hier_level_uses for olapsys.dba$olap2udim_hier_level_uses;
create or replace public synonym dba_olap2_dim_attributes for olapsys.dba$olap2udim_attributes;
create or replace public synonym dba_olap2_dim_attr_uses for olapsys.dba$olap2udim_attr_uses;
create or replace public synonym dba_olap2_dim_level_attributes for olapsys.dba$olap2udim_level_attributes;
create or replace public synonym dba_olap2_cube_measure_maps for olapsys.dba$olap2ucube_measure_maps;
create or replace public synonym dba_olap2_fact_level_uses for olapsys.dba$olap2ufact_level_uses;
create or replace public synonym dba_olap2_join_key_column_uses for olapsys.dba$olap2ujoin_key_column_uses;
create or replace public synonym dba_olap2_level_key_col_uses for olapsys.dba$olap2ulevel_key_col_uses;
create or replace public synonym dba_olap2_dim_level_attr_maps for olapsys.dba$olap2udim_level_attr_maps;
create or replace public synonym dba_olap2_catalogs for olapsys.dba$olap2ucatalogs;
create or replace public synonym dba_olap2_entity_desc_uses for olapsys.dba$olap2uentity_desc_uses;
create or replace public synonym dba_olap2_catalog_entity_uses for olapsys.dba$olap2ucatalog_entity_uses;
create or replace public synonym dba_olap2_fact_table_gid for olapsys.dba$olap2ufact_table_gid;
create or replace public synonym dba_olap2_hier_custom_sort for olapsys.dba$olap2uhier_custom_sort;
create or replace public synonym dba_olapmr_facttblkeymaps for
 olapsys.dba$olapmr_FactTblKeyMaps;
create or replace public synonym dba_olapmr_facttblfctmaps for
 olapsys.dba$olapmr_FactTblfctMaps;
create or replace public synonym dba_olap2_listdims for olapsys.dba$olap2ulistdims;
create or replace public synonym dba_olap2_dim_hiers for olapsys.dba$olap2udim_hiers;
create or replace public synonym dba_olap2_hierdims for olapsys.dba$olap2uhierdims;
create or replace public synonym dba_olap2_FactTblKeyMaps
 for olapsys.dba$olap2_facttblkeymaps;
create or replace public synonym dba_olap2_rufcttblkymaps
 for olapsys.dba$olap2_rufcttblkymaps;
create or replace public synonym dba_olap2_FactTblFctMaps
 for olapsys.dba$olap2_FactTblFctMaps;
create or replace public synonym dba_olap2_hierdim_keycol_map
 for olapsys.dba$olap2uhierdim_keycol_map;
create or replace public synonym dba_olapmr_dim_levels_keymaps
 for olapsys.dba$olapmr_dim_levels_keymaps;
create or replace public synonym dba_olap2_dim_levels_keymaps
 for olapsys.dba$olap2_dim_levels_keymaps;
create or replace public synonym dba_olap2_mr_measdimview
 for olapsys.dba$olap2_mr_measdimview;
create or replace public synonym dba_olap9i1_hier_dimensions
 for olapsys.dba$olap9i1_hier_dimensions;
create or replace public synonym dba_olap9i2_hier_dimensions
 for olapsys.dba$olap9i2_hier_dimensions;
create or replace public synonym dba_olap1_cubes
 for olapsys.dba$olap1_cubes;
create or replace public synonym dba_olap2_awviews
 for olapsys.dba$olap2_awviews;
create or replace public synonym dba_olap2_awviewcols
 for olapsys.dba$olap2_awviewcols;
create or replace public synonym dba_olap2_aggregation_uses
 for olapsys.dba$olap2_aggregation_uses;
create or replace public synonym dba_olap2_entity_parameters
 for olapsys.dba$olap2uentity_parameters;
create or replace public synonym dba_olap2_entity_ext_parms
 for olapsys.dba$olap2uentity_ext_parms;