I happen to change the password for the schema owner in my HANA landscape .Changing Password for Schema
owner handled by L T Replication Server is always tricky.The password is also stored in the DB
connection in the SLT system.That means we need to change the password at both the side.
Have tried to simplify the process of password change with below steps. The steps are valid for both schema and SYSTEM accounts.
Before we change the passwords we need to make sure that Replication Jobs are not running :-
goto –> /nltr
put jobs to 0/0 if there is any job in running state.once done with job status check we can go to HANA studio and open SQL editor to change the password.
Alter user <USER-ID> password XXXX
Alter user <USER-ID> disable password lifetime ;
As mentioned above we need to change the password on SLT side as well.
In SLT system , goto –> /ndbco , only change the receiving entry –> Save It
The naming convention for the database connection is: <MT ID>:R:R, e.g. 125:R:R
we can run the validation in SE38 and check if it still works :-
once confirmed ,the password activity is over and we can start the SLT batch jobs.
to change the DATA_ADMIN password , we need to follow the same way as mentioned above :-
Alter user DATA_ADMIN password XXXX
Alter user DATA_ADMIN disable password lifetime ;
All the administrative users need to be informed to update their HANA STUDIO after the password change with new password .