How to reset SAP* user in BW on HANA system

                          

09:07 // Mark Foerster

Hello Jack,
the table USR02 typically isn't buffered any more, so that change should be simple. Log on to the HANA server as sidadm.
hdbsql -i $$ -u SAPSR3 -p password_of_sapsr3
($$ is the instance number of the HANA database)
hdbsql=> update USR02 set uflag=0 where mandt='000' and bname='SAP*'