@@define_ut3_owner_param.sql

column 2 new_value 2 noprint

select null as "2" from dual where 1=0;

spool params.sql.tmp

case

when '&&2' is null then q'[ACCEPT ut3_user CHAR PROMPT 'Provide schema name where synonyms for the utPLSQL v3 should be created ']'

else 'define ut3_user=&&2'

end

from dual;

spool off

set termout on

@params.sql.tmp

set termout off

$ del params.sql.tmp

! rm params.sql.tmp

set termout on

set echo off

set feedback on

set heading off

set verify off

prompt Granting privileges on UTPLSQL objects in &&ut3_owner schema to user &&ut3_user

whenever sqlerror exit failure rollback

whenever oserror exit failure rollback

alter session set current_schema = &&ut3_owner;

prompt Creating synonyms for UTPLSQL objects in &&ut3_owner schema to user &&ut3_user

create or replace synonym &ut3_user..ut_expectation for &&ut3_owner..ut_expectation;

create or replace synonym &ut3_user..ut_expectation_compound for &&ut3_owner..ut_expectation_compound;

create or replace synonym &ut3_user..be_between for &&ut3_owner..be_between;

create or replace synonym &ut3_user..be_empty for &&ut3_owner..be_empty;

create or replace synonym &ut3_user..be_false for &&ut3_owner..be_false;

create or replace synonym &ut3_user..be_greater_or_equal for &&ut3_owner..be_greater_or_equal;

create or replace synonym &ut3_user..be_greater_than for &&ut3_owner..be_greater_than;

create or replace synonym &ut3_user..be_less_or_equal for &&ut3_owner..be_less_or_equal;

create or replace synonym &ut3_user..be_less_than for &&ut3_owner..be_less_than;

create or replace synonym &ut3_user..be_like for &&ut3_owner..be_like;

create or replace synonym &ut3_user..be_not_null for &&ut3_owner..be_not_null;

create or replace synonym &ut3_user..be_null for &&ut3_owner..be_null;

create or replace synonym &ut3_user..be_true for &&ut3_owner..be_true;

create or replace synonym &ut3_user..equal for &&ut3_owner..equal;

create or replace synonym &ut3_user..have_count for &&ut3_owner..have_count;

create or replace synonym &ut3_user..match for &&ut3_owner..match;

create or replace synonym &ut3_user..ut for &&ut3_owner..ut;

create or replace synonym &ut3_user..ut_runner for &&ut3_owner..ut_runner;

create or replace synonym &ut3_user..ut_teamcity_reporter for &&ut3_owner..ut_teamcity_reporter;

create or replace synonym &ut3_user..ut_xunit_reporter for &&ut3_owner..ut_xunit_reporter;

create or replace synonym &ut3_user..ut_junit_reporter for &&ut3_owner..ut_junit_reporter;

create or replace synonym &ut3_user..ut_tfs_junit_reporter for &&ut3_owner..ut_tfs_junit_reporter;

create or replace synonym &ut3_user..ut_documentation_reporter for &&ut3_owner..ut_documentation_reporter;

create or replace synonym &ut3_user..ut_coverage_html_reporter for &&ut3_owner..ut_coverage_html_reporter;

create or replace synonym &ut3_user..ut_coverage_sonar_reporter for &&ut3_owner..ut_coverage_sonar_reporter;

create or replace synonym &ut3_user..ut_coveralls_reporter for &&ut3_owner..ut_coveralls_reporter;

create or replace synonym &ut3_user..ut_coverage_cobertura_reporter for &&ut3_owner..ut_coverage_cobertura_reporter;

create or replace synonym &ut3_user..ut_reporters for &&ut3_owner..ut_reporters;

create or replace synonym &ut3_user..ut_varchar2_list for &&ut3_owner..ut_varchar2_list;

create or replace synonym &ut3_user..ut_varchar2_rows for &&ut3_owner..ut_varchar2_rows;

create or replace synonym &ut3_user..ut_integer_list for &&ut3_owner..ut_integer_list;

create or replace synonym &ut3_user..ut_reporter_base for &&ut3_owner..ut_reporter_base;

create or replace synonym &ut3_user..ut_output_reporter_base for &&ut3_owner..ut_output_reporter_base;

create or replace synonym &ut3_user..ut_coverage for &&ut3_owner..ut_coverage;

create or replace synonym &ut3_user..ut_coverage_options for &&ut3_owner..ut_coverage_options;

create or replace synonym &ut3_user..ut_coverage_helper for &&ut3_owner..ut_coverage_helper;

create or replace synonym &ut3_user..ut_output_buffer_base for &&ut3_owner..ut_output_buffer_base;

create or replace synonym &ut3_user..ut_output_table_buffer for &&ut3_owner..ut_output_table_buffer;

create or replace synonym &ut3_user..ut_file_mappings for &&ut3_owner..ut_file_mappings;

create or replace synonym &ut3_user..ut_file_mapping for &&ut3_owner..ut_file_mapping;

create or replace synonym &ut3_user..ut_file_mapper for &&ut3_owner..ut_file_mapper;

create or replace synonym &ut3_user..ut_key_value_pairs for &&ut3_owner..ut_key_value_pairs;

create or replace synonym &ut3_user..ut_key_value_pair for &&ut3_owner..ut_key_value_pair;

create or replace synonym &ut3_user..ut_compound_data_tmp for &&ut3_owner..ut_cursor_data;

create or replace synonym &ut3_user..ut_sonar_test_reporter for &&ut3_owner..ut_sonar_test_reporter;

$if dbms_db_version.version = 12 and dbms_db_version.release >= 2 or dbms_db_version.version > 12 $then

execute immediate 'create or replace synonym &ut3_user..dbmspcc_blocks for &&ut3_owner..dbmspcc_blocks';

execute immediate 'create or replace synonym &ut3_user..dbmspcc_runs for &&ut3_owner..dbmspcc_runs';

execute immediate 'create or replace synonym &ut3_user..dbmspcc_units for &&ut3_owner..dbmspcc_units';

$else

null;

$end

end;