Rem
Rem Copyright (c) 2004, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      amde101.sql - migration script for downgrading olap catalog component
Rem
Rem    DESCRIPTION
Rem      Downgrade OLAP Catalog to 10.1.0
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    glyon       07/16/08 - restore select privilege on sys.user$
Rem    cdalessi    05/18/05 - drop odm$olap2udim_hier_level_uses
Rem    cdalessi    05/26/04 - cdalessi_txn111650
Rem    cdalessi    05/26/04 - Creation

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

drop view olapsys.odm$olap2udim_hier_level_uses;

grant select on sys.user$ to olapsys;

execute sys.dbms_registry.downgraded('AMD', '10.1.0');