-- 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 ' 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')); 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 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