Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\roles_object

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\roles_object_rights.sql

begin
declare
  l_pdbuser varchar2(30);

procedure grant_java(p_classname in varchar2) is
     l_shortname varchar2(56);
  begin
     select dbms_java.shortname(p_classname) into l_shortname from dual;
     execute immediate ('grant execute on "'|| l_shortname || '" to OWB_USER');
  end grant_java;

begin
  execute immediate('grant all on wb_rtv_dp_bus_attr_maps to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_bus_rule_stats to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_bus_table_stats to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_columninfo to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_columnstats to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_configstats to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_constraintinfo to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_debug to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_domainvalues to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_errorhandler to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_fdvalues to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_fkcardinality to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_fkconfig to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_fkvalues to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_fkvalues_v to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_partition_metadata to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_rdntvalues to OWB_USER ');
  execute immediate('grant all on wb_rtv_dp_tableinfo to OWB_USER  ');
  execute immediate('grant all on wb_rtv_dp_tablestats to OWB_USER ');
  execute immediate('grant create database link to OWB_USER ');
  execute immediate('grant delete on wb_rt_audit_deployments to OWB_USER ');
  execute immediate('grant delete on wb_rt_audit_executions to OWB_USER ');
  execute immediate('grant execute on object_deployment_action to OWB_USER ');
  execute immediate('grant execute on object_deployment_status to OWB_USER ');
  execute immediate('grant execute on owb_timeseries to OWB_USER ');
  execute immediate('grant execute on owbb_uix to OWB_USER ');
  execute immediate('grant execute on owbrtps_key_to_instance to OWB_USER ');
  execute immediate('grant execute on owbrtps_key_to_version to OWB_USER ');
  execute immediate('grant execute on owbrtps_key_to_version_string to OWB_USER ');
  execute immediate('grant execute on owm_view_utilities to OWB_USER ');
  execute immediate('grant execute on service_available to OWB_USER ');
  execute immediate('grant execute on successful_object_deployment to OWB_USER ');
  execute immediate('grant execute on wb_rt_api_exec to OWB_USER ');
  execute immediate('grant execute on wb_rt_api_purge to OWB_USER ');
  execute immediate('grant execute on wb_rt_audit_purge to OWB_USER ');
  execute immediate('grant execute on wb_rt_audit_shadow_table to OWB_USER ');
  execute immediate('grant execute on wb_rt_constants to OWB_USER ');
  execute immediate('grant execute on wb_rt_conversions to OWB_USER ');
  execute immediate('grant execute on wb_rt_deployment to OWB_USER ');
  execute immediate('grant execute on wb_rt_deployment_control to OWB_USER ');
  execute immediate('grant execute on wb_rt_execution to OWB_USER ');
  execute immediate('grant execute on wb_rt_execution_control to OWB_USER ');
  execute immediate('grant execute on wb_rt_execution_feedback to OWB_USER ');
  execute immediate('grant execute on wb_rt_getError to OWB_USER ');
  execute immediate('grant execute on wb_rt_getErrorWithName to OWB_USER  ');
  execute immediate('grant execute on wb_rt_getPartitionProperties to OWB_USER  ');
  execute immediate('grant execute on wb_rt_get_elapsed_time to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_job_metrics to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_last_execution_time to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_map_run_audit_id to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_number_of_errors to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_number_of_warnings to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_parent_audit_id to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_return_code to OWB_USER ');
  execute immediate('grant execute on wb_rt_get_start_time to OWB_USER ');
  execute immediate('grant execute on wb_rt_integer_version_number to OWB_USER ');
  execute immediate('grant execute on wb_rt_is_platform_repository to OWB_USER ');
  execute immediate('grant execute on wb_rt_message_text to OWB_USER ');
  execute immediate('grant execute on wb_rt_minimum_service_version to OWB_USER ');
  execute immediate('grant execute on wb_rt_notification to OWB_USER ');
  execute immediate('grant execute on wb_rt_pattern_analysis to OWB_USER  ');
  execute immediate('grant execute on wb_rt_platform_repository to OWB_USER ');
  execute immediate('grant execute on wb_rt_profile_service to OWB_USER  ');
  execute immediate('grant execute on wb_rt_script_util to OWB_USER ');
  execute immediate('grant execute on wb_rt_scriptprocessor to OWB_USER ');
  execute immediate('grant execute on wb_rt_service_doctor to OWB_USER ');
  execute immediate('grant execute on wb_rt_service_management to OWB_USER ');
  execute immediate('grant execute on wb_rt_state_variable to OWB_USER ');
  execute immediate('grant execute on wb_rt_store_registration to OWB_USER ');
  execute immediate('grant execute on wb_rt_target_schema_objs to OWB_USER ');
  execute immediate('grant execute on wb_rt_task_variable to OWB_USER ');
  execute immediate('grant execute on wb_rt_transaction_handler to OWB_USER  ');
  execute immediate('grant execute on wb_rt_updateProperties to OWB_USER ');
  execute immediate('grant execute on wb_rt_user_value_admin to OWB_USER ');
  execute immediate('grant execute on wb_rt_version to OWB_USER ');
  execute immediate('grant execute on wb_rt_upgrade to OWB_USER ');
  execute immediate('grant execute on wb_rt_upgrade_ts to OWB_USER ');
  execute immediate('grant execute on wb_rt_tf_map_operations to OWB_USER  ');
  execute immediate('grant execute on wb_rtu_transaction_handler to OWB_USER  ');
  execute immediate('grant select on all_rt_audit_deployments to OWB_USER ');
  execute immediate('grant select on all_rt_audit_exec_files to OWB_USER ');
  execute immediate('grant select on all_rt_audit_exec_messages to OWB_USER ');
  execute immediate('grant select on all_rt_audit_execution_params to OWB_USER ');
  execute immediate('grant select on all_rt_audit_executions to OWB_USER ');
  execute immediate('grant select on all_rt_audit_location_files to OWB_USER ');
  execute immediate('grant select on all_rt_audit_location_messages to OWB_USER ');
  execute immediate('grant select on all_rt_audit_locations to OWB_USER ');
  execute immediate('grant select on all_rt_audit_map_run_errors to OWB_USER ');
  execute immediate('grant select on all_rt_audit_map_run_sources to OWB_USER ');
  execute immediate('grant select on all_rt_audit_map_run_targets to OWB_USER ');
  execute immediate('grant select on all_rt_audit_map_run_trace to OWB_USER ');
  execute immediate('grant select on all_rt_audit_map_runs to OWB_USER ');
  execute immediate('grant select on all_rt_audit_objects to OWB_USER ');
  execute immediate('grant select on all_rt_audit_proc_run_errors to OWB_USER ');
  execute immediate('grant select on all_rt_audit_script_files to OWB_USER ');
  execute immediate('grant select on all_rt_audit_script_messages to OWB_USER ');
  execute immediate('grant select on all_rt_audit_script_runs to OWB_USER ');
  execute immediate('grant select on all_rt_audit_step_run_sources to OWB_USER ');
  execute immediate('grant select on all_rt_audit_step_run_structs to OWB_USER ');
  execute immediate('grant select on all_rt_audit_step_run_targets to OWB_USER ');
  execute immediate('grant select on all_rt_audit_step_runs to OWB_USER ');
  execute immediate('grant select on all_rt_installations to OWB_USER  ');
  execute immediate('grant select on all_rt_location_parameters to OWB_USER ');
  execute immediate('grant select on all_rt_locations to OWB_USER ');
  execute immediate('grant select on all_rt_objects to OWB_USER ');
  execute immediate('grant select on all_rt_task_parameters to OWB_USER ');
  execute immediate('grant select on all_rt_tasks to OWB_USER ');
  execute immediate('grant select on owbb_design_queries to OWB_USER ');
  execute immediate('grant select on owbb_reports to OWB_USER ');
  execute immediate('grant select on owbb_types to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_activities to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_data_objects to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_deployments to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_fcos to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_location_params to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_object_scripts to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_objects to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_process_comps to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_processes to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_scos to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_script_runs to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_scripts to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_tasks to OWB_USER ');
  execute immediate('grant select on rab_rt_audit_units to OWB_USER ');
  execute immediate('grant select on rab_rt_dep_severity to OWB_USER ');
  execute immediate('grant select on rab_rt_dep_status to OWB_USER ');
  execute immediate('grant select on rab_rt_error_table_rules to OWB_USER ');
  execute immediate('grant select on rab_rt_error_table_severity to OWB_USER ');
  execute immediate('grant select on rab_rt_exception_checks to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_results to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_run_errors to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_run_params to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_run_sources to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_run_targets to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_run_traces to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_step_sources to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_step_structs to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_step_targets to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_act_steps to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_activity to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_activity_runs to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_error_columns to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_error_sources to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_map_status to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_param_names to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_param_values to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_proc_hier to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_proc_run_counts to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_proc_run_metrics to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_proc_results to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_proc_run_params to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_proc_status to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_process to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_process_run_errors to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_process_runs to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_severity to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_source_audits to OWB_USER ');
  execute immediate('grant select on rab_rt_exec_target_audits to OWB_USER ');
  execute immediate('grant select on rab_rt_execution_files to OWB_USER ');
  execute immediate('grant select on rab_rt_execution_messages to OWB_USER ');
  execute immediate('grant select on rab_rt_external_urls to OWB_USER ');
  execute immediate('grant select on rab_rt_file_types to OWB_USER ');
  execute immediate('grant select on rab_rt_installations to OWB_USER ');
  execute immediate('grant select on rab_rt_location_parameters to OWB_USER ');
  execute immediate('grant select on rab_rt_obj_status to OWB_USER ');
  execute immediate('grant select on rab_rt_platform_properties to OWB_USER ');
  execute immediate('grant select on rab_rt_rep_types to OWB_USER ');
  execute immediate('grant select on rab_rt_scr_run_status to OWB_USER ');
  execute immediate('grant select on rab_rt_script_run_files to OWB_USER ');
  execute immediate('grant select on rab_rt_script_run_messages to OWB_USER ');
  execute immediate('grant select on rab_rt_source_target to OWB_USER ');
  execute immediate('grant select on rab_rt_store_details to OWB_USER ');
  execute immediate('grant select on rab_rt_store_param_names to OWB_USER ');
  execute immediate('grant select on rab_rt_store_params to OWB_USER ');
  execute immediate('grant select on rab_rt_store_types to OWB_USER ');
  execute immediate('grant select on rab_rt_task_parameters to OWB_USER ');
  execute immediate('grant select on rab_rt_unit_files to OWB_USER ');
  execute immediate('grant select on rab_rt_unit_messages to OWB_USER ');
  execute immediate('grant select on rab_rt_wh_locations to OWB_USER ');
  execute immediate('grant select on rab_rt_wh_objects to OWB_USER ');
  execute immediate('grant select on wb_rt_temporary_exceptions to OWB_USER ');
  execute immediate('grant select on wb_rt_temporary_target to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_custom_parameters to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_deployments to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_executions to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_files to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_message_lines to OWB_USER  ');
  execute immediate('grant select on wb_rtv_audit_message_params to OWB_USER  ');
  execute immediate('grant select on wb_rtv_audit_messages to OWB_USER  ');
  execute immediate('grant select on wb_rtv_audit_notifications to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_objects to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_parameter_deflts to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_parameters to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_script_runs to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_scripts to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_tasks to OWB_USER ');
  execute immediate('grant select on wb_rtv_audit_units to OWB_USER ');
  execute immediate('grant select on wb_rtv_binary_context_attrs to OWB_USER  ');
  execute immediate('grant select on wb_rtv_def_deployment_adapters to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_execution_adapters to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_execution_operators to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_file_types to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_impl_types to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_object_type_defs to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_object_types to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_operator_results to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_store_type_params to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_store_types to OWB_USER ');
  execute immediate('grant select on wb_rtv_def_system_parameters to OWB_USER ');
  execute immediate('grant select on wb_rtv_deployment_stores to OWB_USER ');
  execute immediate('grant select on wb_rtv_execution_stores to OWB_USER ');
  execute immediate('grant select on wb_rtv_installed_services to OWB_USER ');
  execute immediate('grant select on wb_rtv_locked_deploy_objs to OWB_USER ');
  execute immediate('grant select on wb_rtv_locked_exec_objs to OWB_USER ');
  execute immediate('grant select on wb_rtv_platform_properties to OWB_USER ');
  execute immediate('grant select on wb_rtv_queue_tabs_info to OWB_USER ');
  execute immediate('grant select on wb_rtv_service_nodes to OWB_USER ');
  execute immediate('grant select on wb_rtv_state_variables to OWB_USER ');
  execute immediate('grant select on wb_rtv_store_parameters to OWB_USER ');
  execute immediate('grant select on wb_rtv_stores to OWB_USER ');
  execute immediate('grant select on wb_rtv_task_custom_parameters to OWB_USER ');
  execute immediate('grant select on wb_rtv_task_parameter_defaults to OWB_USER ');
  execute immediate('grant select on wb_rtv_task_parameters to OWB_USER ');
  execute immediate('grant select on wb_rtv_tasks to OWB_USER ');
  execute immediate('grant select on wb_rtv_textual_context_attrs to OWB_USER ');
  execute immediate('grant select on wb_rtv_warehouse_objects to OWB_USER ');
  execute immediate('grant execute on wb_rt_dp_create_fktables to OWB_USER ');
  execute immediate('grant execute on wb_rt_dp_create_fkpartition to OWB_USER ');
  execute immediate('grant execute on wb_rt_dp_create_sample to OWB_USER ');
grant_java('oracle/wh/runtime/server/script/ScriptProcessor') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/Candidate') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/CompositeForeignKey') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/FDBitSet') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/FDValue') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/FKValue') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/ForeignKey') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/FunctionalDependency') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/Partition') ;
grant_java('oracle/wh/service/impl/dataProfile/analysis/storedprocs/PartitionDataHandler') ;
end;
end;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de