rem
rem This script can be used to set the password of the OWB Repository.
rem This password is used by the Control Center Service at startup time.
rem
rem USAGE
rem Logon as the OWB Repository Owner (OWBSYS) and provide its password as a parameter
rem    
rem    @<OWB-HOME>/owb/rtp/sql/set_repository_password.sql <password>
rem
rem This script sets the password for the Repository.
rem

set serveroutput on;

set echo off
set verify off
set role OWB_USER;

define NEW_PASSWORD = &1.

declare
begin
  owbsys.wb_rt_script_util.set_repository_password('&NEW_PASSWORD.');

end;
/

commit;