Rem
Rem
Rem cwm2user.sql
Rem
Rem Copyright (c) 2000, 2004, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2user.sql
Rem
Rem    DESCRIPTION
Rem     This script includes additional grants needed by the olapsys
Rem     for cwm 9i2 release.
Rem     
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem     glyon    06/06/07 - remove grants to olap_dba
Rem     dbardwel 09/29/04 - Added create job priv to OLAP_DBA role.
Rem     dbardwel 02/24/03 - 
Rem     dbardwel 02/18/02 - for component registry allow sys.dbms_registry to olapsys
Rem     dbardwel/mrangwal - 02/04/02 - 3 system table grants to olapsys
Rem     dbardwel 01/23/02 - dbardwel_txn101474
Rem     dbardwel  01/07/02  created.
Rem

grant select on sys.aw$ to olapsys with grant option
/
grant select any table to olapsys
/
grant select, insert, update, delete on system.mview$_adv_output to olapsys
/
grant select, insert, update, delete on system.mview$_adv_partition to olapsys
/
grant select, insert, update, delete on system.mview$_adv_index to olapsys
/
grant execute on sys.dbms_registry to olapsys with grant option;
/