Rem
Rem $Header: onevdgrt.sql 23-dec-2002.15:50:56 cdalessi Exp $
Rem
Rem onevdgrt.sql
Rem
Rem Copyright (c) 2000, 2002, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      onevdgrt.sql - 
Rem
Rem    DESCRIPTION
Rem      Grants dba_olap views to SELECT_CATALOG_ROLE
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    cdalessi    12/23/02 - remove references to olap_child_instances
Rem    dthompso    06/01/00 - Add child_instances_list view
Rem    dthompso    04/26/00 - Initial Version
Rem    dthompso    01/00/00 - Created
Rem

GRANT SELECT ON dba$olap_catalog_entity_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_catalogs TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_columns TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_cube_dim_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_cube_measure_dim_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_cube_measure_maps TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_cube_measures TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_cubes TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_descriptor_types TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_descriptors TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dim_attr_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dim_attributes TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dim_hier_level_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dim_hierarchies TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dim_level_attr_maps TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dim_level_attributes TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dim_levels TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_dimensions TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_entity_desc_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_fact_level_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_foreign_keys TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_function_arguments TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_function_parameters TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_function_usages TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_functions TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_join_key_column_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_key_column_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_keys TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_level_key_column_uses TO SELECT_CATALOG_ROLE
/
GRANT SELECT ON dba$olap_tables TO SELECT_CATALOG_ROLE
/