# Convert to  reset password
sqlplus / as sysdba <<EOF
alter user IBS identified by "IBS";
alter user AUD identified by "AUD";
alter user AUDM identified by "AUDM";
alter user adm_faktura profile BKL_PROC;
alter user adm_faktura identified by "IBS";

-- Drop ACLs
-- exec dbms_network_acl_admin.drop_acl(acl=>'utl_http.xml');

exec dbms_network_acl_admin.drop_acl(acl=>'NETWORK_ACL_351335608781FA79E05302DDA8C046B8');
exec dbms_network_acl_admin.drop_acl(acl=>'NETWORK_ACL_351335608782FA79E05302DDA8C046B8');
exec dbms_network_acl_admin.drop_acl(acl=>'NETWORK_ACL_351335608783FA79E05302DDA8C046B8');
exec dbms_network_acl_admin.drop_acl(acl=>'NETWORK_ACL_351335608784FA79E05302DDA8C046B8');

exit
EOF

# --------------  special actions DBA ----
$SQLDBA <<EOF
connect / as sysdba
--------------  change passw IBS ----
alter user ibs identified by $IBS_PASS;
--------------  drop ALL  jobs ----
delete dba_jobs where what like 'Z\$SYSTEM_JOBS_JOB_LIB.run%';
commit;
--------------  change AUD Mail Name ----
alter trigger AUD.SETTINGS_BEFORE_INS_UPD disable;
alter trigger AUD.AUDIT_SETTINGS_CHANGES disable;
update aud.settings set value='audit_test_'||(select HOST_NAME from V\$INSTANCE) where name='MAIL_DEF_SENDER_NAME';
commit;
alter trigger AUD.SETTINGS_BEFORE_INS_UPD enable;
alter trigger AUD.AUDIT_SETTINGS_CHANGES enable;
--------------  enable ALL user sessions ----
ALTER SYSTEM DISABLE RESTRICTED SESSION;
EOF
## --------------  change IBSO for test copy ----
$SQLDBA <<EOF
connect ibs/IBS
select IBS.RTL.open from dual;
--exec IBS.SysInfo.SetValue ('NOVO.INTERFACE_COLOR', '0xCDD9A8', 'Цвет схемы в навигаторе');
exec IBS.SysInfo.SetValue ('NOVO.INTERFACE_COLOR', '0x66FF66', 'Цвет схемы в навигаторе');
update Z#FP_TUNE_VAL set c_value=(replace(C_VALUE,'192.168.211.127','192.168.211.236')) where upper(c_value) like upper('%192.168.211%');
exec Z\$BGF_DEP_TEST_BGF_14792030962.BGF_BEG_DATE_COR_EXECUTE(NULL,NULL,trunc(sysdate),trunc(sysdate)+1);
commit;
EOF