Rem drv: <migrate type="data_upgrade" version="10.2.0.1"/>
Rem
Rem $Header: user_model_data_upgrade.sql 01-sep-2005.14:37:39 dcawley Exp $
Rem
Rem user_model_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      user_model_data_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    dcawley     09/01/05 - Add header 
Rem    dcawley     09/01/05 - Build flat table 
Rem    dcawley     08/22/05 - dcawley_beta_upgrade_bugs_main
Rem    dcawley     08/19/05 - Created
Rem

Rem
Rem Remove any rows from the target cache table that do not have a valid
Rem target guid
Rem 
DELETE FROM MGMT_USER_TARGETS
WHERE target_guid NOT IN (SELECT target_guid FROM MGMT_TARGETS);
COMMIT;

Rem
Rem Rebuild the flat role grants
Rem
BEGIN
  FOR role in (SELECT role_name FROM MGMT_ROLES)
  LOOP
    MGMT_USER.UPDATE_FLAT_ROLE_GRANTS(role.role_name);
    COMMIT;
  END LOOP;
END;
/