Rem
Rem $Header: amdu901.sql 02-feb-2002.15:13:00 awesley
Rem
Rem amdu901.sql
Rem
Rem Copyright (c) 2002, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      amdu901.sql 
Rem
Rem    DESCRIPTION
Rem      Upgrade cwm2.
Rem
Rem    NOTES
Rem
Rem      
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       06/24/08 - bug 7204558: eliminate references to sys.user$
Rem    awesley     09/21/06 - add call to amdu920.sql
Rem    cdalessi    10/06/04 - Move validation to SYS 
Rem    cdalessi    05/28/04 - Add missing grants.
Rem    cdalessi    12/04/03 - Add validate call.
Rem    cdalessi    11/03/03 - fix banner
Rem    cdalessi    10/21/03 - remove path to cataps.sql
Rem    cdalessi    10/20/03 - add some required grants for dbms_aw_lib
Rem    awesley     09/29/03 - 92041 to main
Rem    awesley     06/02/03 - 
Rem    cdalessi    01/23/03 - 
Rem    cdalessi    01/22/03 - need aps, now
Rem    cdalessi    01/22/03 - remove redundant amdu920 call
Rem    cdalessi    12/09/02 - 10i migration changes
Rem    dbardwel    02/22/02 - dbardwel_txn101968
Rem    dbardwel    02/02/18 - added cwm2user.sql for new permissions needed by olapsys
Rem                           user for the 9i2 release
Rem    dbardwel    02/02/18 - Use final version of sys.dbms_registry call
Rem    awesley     02/02/14 - Created

execute sys.dbms_registry.upgrading('AMD' ,'OLAP Catalog' ,'cwm2_olap_installer.Validate_CWM2_Install' ,'OLAPSYS'); 

Rem Even though APS did not exist in 901, AMD needs it now
@@cataps.sql

grant execute on sys.dbms_aw_lib to olapsys;

alter session set current_schema = olapsys;

@@onevacol.sql
@@onevdcol.sql
@@onepxcpn.pls
@@oneapib.sql

@@cwm2user.sql

grant select on sys.aw_prop$ to olapsys with grant option;
grant select on sys.dba_tables to olapsys;
grant select on sys.dba_constraints to olapsys;
grant select on sys.dba_objects to olapsys;
grant create any dimension to olapsys;
grant drop any dimension to olapsys;
grant select on sys.all_aws to olapsys with grant option;
grant select on sys.all_aw_prop_name to olapsys with grant option;
grant select on sys.view$ to olapsys;
grant select on sys.obj$ to olapsys;
grant select on dba_users to olapsys;
grant select on dba_roles to olapsys;
grant select on dba_role_privs to olapsys;
grant select on sys.dependency$ to olapsys;
grant select on sys.syn$ to olapsys;
grant create any synonym to olapsys;
grant drop any synonym to olapsys;

@@cwm2inst.sql

drop public synonym cwm2_olap_installer;
drop package olapsys.cwm2_olap_installer;

execute sys.dbms_registry.upgraded('AMD');

alter session set current_schema = sys;

@@cwm2iner.pls
@@cwm2iner.plb

execute sys.cwm2_olap_installer.Validate_CWM2_Install;

@@amdu920.sql