19 February 2009

Change Livecache user password

I recently had an issue changing the Livecache user in a SCM 5.0 system.
Changing the password in the ABAP stack transaction LC10 was easy.
But you also have the change the password in the Livecache database.

So do that you need the following commands.

(XXX is the database name)
1.Start the Livecache DB command line : dbmcli -d XXX -u control,[password]
2. Login as Superdba : sql_connect superdba,[password]
3.Change Livecache user password : sql_execute alter password sapr3 [new password]
4. Make the new password known : user_sap sapr3,[new password]

If you don't know the SuperDBA password you can execute the following command after step 1 above : user_put superdba password=[new password]