Rem
Rem $Header: onevagrt.sql 23-dec-2002.15:50:55 cdalessi Exp $
Rem
Rem onevagrt.sql
Rem
Rem Copyright (c) 2000, 2002, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      onevagrt.sql
Rem
Rem    DESCRIPTION
Rem      Grants set of all_olap views making up API to the role PUBLIC
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    cdalessi    12/23/02 - remove references to olap_child_instances
Rem    dthompso    02/27/01 - change security implementation
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 all$olap_catalog_entity_uses TO PUBLIC
/
GRANT SELECT ON all$olap_catalogs TO PUBLIC
/ 
GRANT SELECT ON all$olap_columns TO PUBLIC
/
GRANT SELECT ON all$olap_cube_dim_uses TO PUBLIC
/
GRANT SELECT ON all$olap_cube_measure_dim_uses TO PUBLIC
/
GRANT SELECT ON all$olap_cube_measure_maps TO PUBLIC
/
GRANT SELECT ON all$olap_cube_measures TO PUBLIC
/
GRANT SELECT ON all$olap_cubes TO PUBLIC
/
GRANT SELECT ON all$olap_descriptor_types TO PUBLIC
/
GRANT SELECT ON all$olap_descriptors TO PUBLIC
/
GRANT SELECT ON all$olap_dim_attr_uses TO PUBLIC
/
GRANT SELECT ON all$olap_dim_attributes TO PUBLIC
/
GRANT SELECT ON all$olap_dim_hier_level_uses TO PUBLIC
/
GRANT SELECT ON all$olap_dim_hierarchies TO PUBLIC
/
GRANT SELECT ON all$olap_dim_level_attr_maps TO PUBLIC
/
GRANT SELECT ON all$olap_dim_level_attributes TO PUBLIC
/
GRANT SELECT ON all$olap_dim_levels TO PUBLIC
/
GRANT SELECT ON all$olap_dimensions TO PUBLIC
/
GRANT SELECT ON all$olap_entity_desc_uses TO PUBLIC
/
GRANT SELECT ON all$olap_fact_level_uses TO PUBLIC
/
GRANT SELECT ON all$olap_foreign_keys TO PUBLIC
/
GRANT SELECT ON all$olap_function_arguments TO PUBLIC
/
GRANT SELECT ON all$olap_function_parameters TO PUBLIC
/
GRANT SELECT ON all$olap_function_usages TO PUBLIC
/
GRANT SELECT ON all$olap_functions TO PUBLIC
/
GRANT SELECT ON all$olap_join_key_column_uses TO PUBLIC
/
GRANT SELECT ON all$olap_key_column_uses TO PUBLIC
/
GRANT SELECT ON all$olap_keys TO PUBLIC
/
GRANT SELECT ON all$olap_level_key_column_uses TO PUBLIC
/
GRANT SELECT ON all$olap_tables TO PUBLIC
/