Rem
Rem $Header: cwm2mrgt.sql 21-jan-2004.10:28:29 cdalessi Exp $
Rem
Rem cwm2mrgt.sql
Rem
Rem Copyright (c) 2002, 2004, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2mrgt.sql - grant script for new performance 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 specific privs
Rem    cdalessi    01/21/04 - Move package grants to new file
Rem    mstasiew    09/24/03 - 
Rem    mstasiew    06/10/03 - 
Rem    mstasiew    06/09/03 - 
Rem    mstasiew    05/16/03 - 
Rem    glyon       12/31/02 - backport of mstasiew_txn105532
Rem    dbardwel    09/18/02 - 
Rem    dbardwel    09/17/02 - 
Rem    mstasiew    08/16/02 - 
Rem    mstasiew    08/02/02 - mstasiew_txn103451
Rem    mstasiew    07/25/02 - 
Rem    dbardwel    07/24/02 - Created
Rem

grant select on mrv$olap2_awviews to public
/

grant select on mrv$olap2_awviewcols to public
/

grant select on mrv$olap2_catalogs to public
/

grant select on mrv$olap2_catalog_entity_uses to public
/

grant select on mrv$olap2_listdims_cc to public
/

grant select on mrv$olap2_listdims to public
/

grant select on mrv$olap2_dim_hiers to public
/

grant select on mrv$olap2_hierdims_cc to public
/

grant select on mrv$olap2_hierdims to public
/

grant select on mrv$olap2_dim_hier_level_uses to public
/

grant select on mrv$olap2_join_key_col_uses to public
/

grant select on mrv$olap2_dim_attributes to public
/

grant select on mrv$olap2_entity_desc_uses to public
/

grant select on mrv$olap2_descriptors to public
/

grant select on mrv$olap2_dim_level_attr_maps to public
/

grant select on mrv$olap2_cube_measures to public
/

grant select on mrv$olap2_facttblkeymaps to public
/

grant select on mrv$olap1_facttblkeymaps to public
/

grant select on mrv$olap2_facttblfctmaps to public
/

grant select on mrv$olap1_facttblfctmaps to public
/

grant select on mrv$olap2_hierdim_keycol_map to public
/

grant select on mrv$olap2_hier_custom_sort to public
/

grant select on mrv$olap1_pop_dimensions to public
/

grant select on mrv$olap1_pop_cubes to public
/

grant select on olapsys.mrv$olap2_agg_uses to public
/

grant select on olapsys.mrv$mrall_cwm1_aggop to public
/

grant select on olapsys.mrv$mrall_cwm1_aggord to public
/

grant select on olapsys.mrv$mrall_entity_parameters to public
/

grant select on olapsys.mrv$mrall_entity_ext_parms to public
/

grant select on mrv$olap2_pop_dimensions to public
/

grant select on mrv$olap2_pop_cubes to public
/

grant select, insert, delete on olapsys.olap_session_dims to public
/

grant select, insert, delete on olapsys.olap_session_cubes to public
/