Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\upg\upg102to10203.sql

-- In-place Design Repository Upgrade to OWB 10.2.0.3 ...

ACCEPT V_HOST PROMPT 'Host Name: '
ACCEPT V_PORT PROMPT 'Port Number: '
ACCEPT V_SERVICENAME PROMPT 'Service Name: '
ACCEPT V_USER_NAME PROMPT 'Existing OWB Repository Owner Username: '
ACCEPT V_USER_PASSWORD PROMPT 'Existing OWB Repository Owner Password: ' HIDE
ACCEPT V_SYS_USER_NAME PROMPT 'SYS User Name: '
ACCEPT V_SYS_USER_PASSWORD PROMPT 'SYS User Password: '  HIDE
PROMPT 
PROMPT Review above entries and press
ACCEPT V_DUMMY PROMPT ' <ENTER> to continue or Ctrl-C to cancel'
 
PROMPT Start Repository upgrade from OWB 10.2.0.1/10.2.0.2 to OWB 10.2.0.3 ...
 
PROMPT Start updating User Grants for OWB 10.2.0.3.0 Repository...

PROMPT Connect to SYS user ...
WHENEVER SQLERROR EXIT FAILURE
connect &V_SYS_USER_NAME/&V_SYS_USER_PASSWORD@(DESCRIPTION=(ADDRESS=(HOST= &V_HOST )(PROTOCOL=tcp)(PORT= &V_PORT ))(CONNECT_DATA=(SERVICE_NAME= &V_SERVICENAME ))) AS SYSDBA
WHENEVER SQLERROR CONTINUE
 
SPOOL LOG.TXT
 
drop package UpdateReposUsers;
@UpdateReposUsers.pks
@UpdateReposUsers.pkb
 
SET ESCAPE %
 
PROMPT bug 5330707
grant  SELECT, INSERT, DELETE, UPDATE on &V_USER_NAME%.DROP_MISC_OBJECTS to OWB_&V_USER_NAME;
 
PROMPT bug 5568194
grant EXECUTE on &V_USER_NAME%.wb_rti_target_schema_privs to OWB_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_target_schema_objs to OWB_&V_USER_NAME;
 
PROMPT bug 5565683
grant SELECT on &V_USER_NAME%.all_iv_COLLECTION_REFERENCES to OWBR_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.ALL_IV_PLS_RECORDS  to OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERTS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_MODULES  to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_VARIABLES to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_PARAMETERS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_TRANSITIONS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_NESTED_EXPERTS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_EXPERT_TASKS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.OWB_XML_MODULES  to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.OWB_SQL_COLLECTIONS   to OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_MODULES  to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_FCOS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_FOLDERS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_SCOS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_UDO_ASSOCIATIONS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_PLUG_MAP_COMPONENTS to  OWBR_&V_USER_NAME;
grant select on &V_USER_NAME%.ALL_IV_PLUG_MAP_PARAMETERS to  OWBR_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_store_types to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_store_type_params to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_deployment_adapters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_impl_types to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_object_types to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_object_type_defs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_execution_adapters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_execution_operators to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_operator_results to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_system_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_def_file_types to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_execution_stores to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_platform_properties to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_stores to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_store_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_warehouse_objects to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_tasks to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_task_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_task_custom_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_task_parameter_defaults to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_deployments to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_units to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_objects to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_tasks to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_custom_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_parameter_deflts to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_scripts to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_script_runs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_executions to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_files to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_messages to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_message_lines to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_audit_message_params to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_binary_context_attrs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_textual_context_attrs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_state_variables to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_locked_deploy_objs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_locked_exec_objs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_deployment_stores to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.object_deployment_status to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.successful_object_deployment to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.object_deployment_action to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.service_available to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_version to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_is_platform_repository to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_message_text to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_installations to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_locations to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_location_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_objects to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_tasks to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_task_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_locations to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_location_messages to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_location_files to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_objects to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_script_runs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_script_messages to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_script_files to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_executions to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_execution_params to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_exec_messages to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_exec_files to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_map_runs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_map_run_sources to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_map_run_targets to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_step_runs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_step_run_sources to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_step_run_targets to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_map_run_errors to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_map_run_trace to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.all_rt_audit_deployments to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_activities to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_data_objects to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_deployments to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_fcos to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_location_params to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_objects to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_object_scripts to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_processes to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_process_comps to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_scos to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_scripts to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_script_runs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_tasks to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_audit_units to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_dep_severity to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_dep_status to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_error_table_rules to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_error_table_severity to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exception_checks to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_execution_files to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_execution_messages to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_activity to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_activity_runs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_results to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_run_errors to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_run_params to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_run_sources to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_run_targets to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_run_traces to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_steps to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_step_sources to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_step_structs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_act_step_targets to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_error_columns to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_error_sources to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_map_status to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_param_names to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_param_values to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_process to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_process_runs to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_process_run_errors to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_proc_run_params to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_proc_results to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_proc_status to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_severity to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_source_audits to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_exec_target_audits to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_external_urls to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_file_types to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_installations to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_location_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_obj_status to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_platform_properties to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_rep_types to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_script_run_files to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_script_run_messages to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_scr_run_status to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_source_target to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_store_details to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_store_params to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_store_types to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_store_param_names to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_task_parameters to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_unit_files to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_unit_messages to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_wh_locations to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.rab_rt_wh_objects to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rt_temporary_exceptions to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rt_temporary_target to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.owbb_uix to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.owbb_reports to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.owbb_design_queries to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_service_nodes to owb_o_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rtv_installed_services to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_integer_version_number to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.owbrtps_key_to_instance to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.owbrtps_key_to_version to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_minimum_service_version to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_api_exec to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_audit_shadow_table to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_execution to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_execution_control to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_execution_feedback to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_notification to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_constants to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_conversions to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_task_variable to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_elapsed_time to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_job_metrics to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_map_run_audit_id to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_last_execution_time to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_number_of_errors to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_number_of_warnings to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_parent_audit_id to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_return_code to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_start_time to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_target_schema_objs to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_deployment to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_deployment_control to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_notification to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_constants to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_conversions to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_task_variable to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_elapsed_time to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_job_metrics to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_map_run_audit_id to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_last_execution_time to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_number_of_errors to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_number_of_warnings to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_parent_audit_id to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_return_code to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_start_time to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_store_registration to owb_d_&V_USER_NAME;
grant create database link to owb_d_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_service_management to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_user_value_admin to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_api_purge to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_audit_purge to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_notification to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_constants to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_conversions to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_task_variable to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_elapsed_time to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_job_metrics to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_map_run_audit_id to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_last_execution_time to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_number_of_errors to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_number_of_warnings to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_parent_audit_id to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_return_code to owb_a_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_get_start_time to owb_a_&V_USER_NAME;
grant delete on &V_USER_NAME%.wb_rt_audit_deployments to owb_a_&V_USER_NAME;
Grant delete on &V_USER_NAME%.wb_rt_audit_executions to owb_a_&V_USER_NAME;
grant SELECT on &V_USER_NAME%.wb_rt_specified_user_values to owb_a_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_fkvalues_v to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_bus_rule_stats to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_bus_table_stats to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_bus_attr_maps to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_columninfo to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_constraintinfo to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_columnstats to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_configstats to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_domainvalues to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_fkconfig to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_fkvalues to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_fkcardinality to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_rdntvalues to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_tableinfo to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_tablestats to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_partition_metadata to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_fdvalues to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_debug to owb_o_&V_USER_NAME;
grant all on &V_USER_NAME%.wb_rtv_dp_errorhandler to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_profile_service to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_transaction_handler to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rtu_transaction_handler to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_pattern_analysis to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_getPartitionProperties to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_getErrorWithName to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_getError to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_updateProperties to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.owb_timeseries to owb_o_&V_USER_NAME;

-- Give permission to OWB owner to access OWBRT_SYS.OWBRTPS
grant SELECT, INSERT, UPDATE, DELETE on OWBRT_SYS.OWBRTPS to &V_USER_NAME;
 
-- Update all repository users version numbers
exec UpdateReposUsers.UpdReposUsers(%'&V_USER_NAME%', '10.2.0.3.0');
commit;
 
SET ESCAPE OFF;
 
PROMPT Connect to Design repository user ...
WHENEVER SQLERROR EXIT FAILURE
connect &V_USER_NAME/&V_USER_PASSWORD@(DESCRIPTION=(ADDRESS=(HOST= &V_HOST )(PROTOCOL=tcp)(PORT= &V_PORT ))(CONNECT_DATA=(SERVICE_NAME= &V_SERVICENAME )))
WHENEVER SQLERROR CONTINUE
 
PROMPT bug 5518634/5504597/5867757/5915443
@../../rtasst/wb_rt_profile.sql
@../../rtasst/wb_rt_profile_service.pls
@../../rtasst/wb_rt_profile_service.plb
@../../rtasst/wb_rt_target_schema_objs.pls
@../../rtasst/wb_rt_target_schema_objs.plb 
@../../rtasst/wb_rti_target_schema_privs.pls
@../../rtasst/wb_rti_target_schema_privs.plb
@../../rtasst/wb_rt_conversions.pls
@../../rtasst/wb_rt_conversions.plb
@../../rtasst/wb_rt_pattern_analysis.pls
@../../rtasst/wb_rt_pattern_analysis.plb
@../../rtasst/wb_rti_workflow_util.pls
@../../rtasst/wb_rti_workflow_util.plb

PROMPT bug 5517112 
@../../rtasst/wb_rt_platform_audit_views.sql

PROMPT bug 5658484
drop package fix_5658484;
@fix5658484.pks
@fix5658484.pkb
SET ESCAPE %
exec fix_5658484.do_fix_5658484(%'&V_USER_NAME%');
SET ESCAPE OFF;

PROMPT bug 5128822 / 5123703
@../../browserasst/views/public_utils.sql 
@../../browserasst/views/public_utils_body.plb 
@../../browserasst/views/public_views.sql

PROMPT bugs 5390587/5417117/5352671/5385670/5754997
@../SnapshotTrigger.pks
@../SnapshotTrigger.plb
@../SnapshotCreateRestore.pks
@../SnapshotGenerated.pks
@../Snapshot.pks
@../SnapshotMXS.pks
@../SnapshotImport.pks
@../SnapshotError.pks
@../SnapshotTrigger.plb
@../SnapshotCreateRestore.plb
@../SnapshotGenerated.plb
@../Snapshot.plb
@../SnapshotMXS.plb
@../SnapshotImport.plb
@../SnapshotError.plb

PROMPT bug 5865722
@fix5865722.sql

PROMPT bug 5905503
@fix5905503.sql

PROMPT bug 6062030
@fix6062030.sql

PROMPT bug 5747781
@matchmerge.pls
@matchmerge.plb

PROMPT bug5988620
@fix5988620.sql

PROMPT bug 5442191
@fix5442191.sql
@fix5442191_p2.sql

PROMPT bug 6143867
@fix6143867.sql
@fix6143867_p2.sql
@sapftp.sql

PROMPT bug 6168166
@fix6168166.sql

PROMPT bug 6131908
@fix6131908.sql

PROMPT bug 5479145
@property_upgrade_102to10203.sql;

PROMPT Invoke upversion_10203.sql ...
@upversion_10203.sql;

PROMPT update OWBRT_SYS.OWBRTP table
@owbrt_sys.sql
commit;

PROMPT Re-load fd.jar here
@load_java.sql V_USER_NAME V_USER_PASSWORD

PROMPT Recompile packages... 1st pass
exec DBMS_UTILITY.COMPILE_SCHEMA (UPPER('&V_USER_NAME'));
PROMPT Recompile packages... 2nd pass
exec DBMS_UTILITY.COMPILE_SCHEMA (UPPER('&V_USER_NAME'));
PROMPT Recompile packages... 3rd pass
exec DBMS_UTILITY.COMPILE_SCHEMA (UPPER('&V_USER_NAME'));

SET ESCAPE %
-- Set these grants here.
grant EXECUTE on &V_USER_NAME%.wb_rt_dp_create_fkpartition to owb_o_&V_USER_NAME;
grant EXECUTE on &V_USER_NAME%.wb_rt_dp_create_fktables to owb_o_&V_USER_NAME;

-- Revoke permission to OWB owner to access OWBRT_SYS.OWBRTPS
revoke SELECT, INSERT, UPDATE, DELETE on OWBRT_SYS.OWBRTPS from &V_USER_NAME;

PROMPT End of the upgrade.
SPOOL OFF
exit

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de