Changing the Password of the HANA Schema Owner

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.

DATA_ADMIN Password

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 .