REM
REM Copyright (c) 2002, 2008, Oracle. All rights reserved.
REM
REM  FILE
REM   cwm2awcg.sql
REM
REM  DESCRIPTION
REM   Grant script for CWM2_OLAP_AW_CREATE package new
REM   for 9.2.0.2.0
REM
REM  NOTES
REM    New in 9.2.0.2.0 Patch Release
REM
REM  MODIFIED  (MM/DD/YY)
REM     glyon   08/06/08 - bug 7231135: add grant on dbms_awm to olap_user
REM     glyon   11/06/07 - bug 6596816: replace grant all with needed prvs
REM     glyon   06/04/07 - replace public with cwm_user in grant execute
REM     dbardwe 09/13/04 - Remove dbms_aw_utilities grant 
REM     dbardwe 05/19/04 - Added missing grant on XML_LOADID_SEQUENCE sequence
REM     cdaless 06/09/03 - add dbms_awm
REM     dbardwe 01/15/03 - Allow users to select from OLAP Enablement sequence
REM     cdaless 12/23/02 - 
REM     cdaless 12/18/02 - yank out refs to cwm2_olap_aw_create
REM     amboya  12/09/02 - Fix to bug 2698866 - CWM2_OLAP_AW_ACCESS REQUIRES NAME UPDATE
REM     amboya  10/01/02 - 
REM     dbardwe 09/11/02 - 
REM     dbardwe 08/19/02 - dbardwel_txn103971
REM   dbardwel  08/16/02  Created.
REM

grant execute on cwm2_olap_olapapi_enable to CWM_USER
/

grant select, insert, delete on cwm2$AWDimCreateAccess to CWM_USER
/

grant select, insert, delete on cwm2$AWCubeCreateAccess to CWM_USER
/

grant execute on cwm2_olap_aw_awutil to CWM_USER
/

grant select on cwm2_olap_enableseq to CWM_USER
/

grant execute on dbms_awm to CWM_USER, OLAP_USER;
/

grant select on XML_LOADID_SEQUENCE to OLAP_USER, OLAP_DBA
/