Rem
Rem $Header:	cwm2apig.sql 05_nov-2001.10:11:00 awesley Exp $
Rem
Rem cwm2apig.sql
Rem
Rem Copyright (c) 2001, 2004, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      cwm2apig.sql 
Rem
Rem    DESCRIPTION
Rem      Grants access privileges to all users on cwm2 API packages.
Rem
Rem    NOTES
Rem      
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem       glyon    06/04/07 - replace public with cwm_user in grant execute
Rem       cdalessi 10/06/04 - Move validation to SYS 
Rem       dbardwel 09/13/04 - Remove reference to dbms_aw_utilities obsolete now.
Rem       awesley  11/18/03 - add export ,delete
Rem       awesley  09/29/03 - 92041 to main
Rem       dbardwel 09/09/03 - 
Rem    Aziz.Mboya  09/02/03 - amboya_txn108623. Code cleanup for package name change from cwm2_olap_aw_access to dbms_aw_utilities.
Rem       awesley  09/27/02 - 
Rem       awesley  09/11/02 - 
Rem       awesley  09/09/02 - 
Rem       awesley  09/05/02 - 
Rem       awesley  08/29/02 - 
Rem       awesley  08/28/02 - 
Rem    Aziz.Mboya  01/29/02 - changed package name from cwm2_olap_awconvert to cwm2_olap_aw_access
Rem    dbardwel    01/24/02 - added 2 missing packages 
Rem    awesley     11/06/01 - awesley_txn100587
Rem    dthompso    11/05/01 - Created
Rem

grant execute on cwm2_olap_exceptions to CWM_USER
/
grant execute on cwm2_olap_manager to CWM_USER
/
grant execute on cwm2_olap_utility to CWM_USER
/
grant execute on cwm2_olap_catalog to CWM_USER
/
grant execute on cwm2_olap_cube to CWM_USER
/
grant execute on cwm2_olap_dimension to CWM_USER
/
grant execute on cwm2_olap_dimension_attribute to CWM_USER
/
grant execute on cwm2_olap_hierarchy to CWM_USER
/
grant execute on cwm2_olap_level to CWM_USER
/
grant execute on cwm2_olap_level_attribute to CWM_USER
/
grant execute on cwm2_olap_measure to CWM_USER
/
grant execute on cwm2_olap_validate to CWM_USER
/
grant execute on cwm2_olap_verify_access to CWM_USER
/
grant execute on cwm2_olap_export to CWM_USER
/
grant execute on cwm2_olap_delete to CWM_USER
/
grant execute on cwm2_olap_table_map to CWM_USER
/
grant execute on cwm2_olap_pc_transform to CWM_USER
/
grant execute on cwm2$security to CWM_USER
/
grant execute on cwm2_olap_classify to public
/