How to reset SAP* user in BW on HANA system

[Former Member]

Hello

The license on BW on HANA system has expired and we want to use SAP* user to login to system and install new license.

My question is how can I reset SAP* user if the user is locked due to too many failed logon attempts?

[former_member217141]

This message was moderated.

[Former Member]

Hello, Thanks to all your replies.

Using SAP HANA Studio SQL editor as the schema owner SAP<SID and running the standard SAP* delete sql statement worked fine.

Thank you

[former_member282800]

This message was moderated.

[Former Member]

Hi all,

you can also delete SAP* (bname) user from table USR02 using SQL command in HANA Studio, given the fact that SAP* user is hardcoded, it will regenerated and you can logon with 06071992.

I have checked this on our system the Schema is SAP<SID> as mentioned by Srinivas. You have to make sure that you have appropriate rights to change tables in SAP BW schema.

Best Regards,

Marcel

[Former Member]

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*'

Regards,

Mark

[SK-EA]

Mark,

I believe the schema name would be SAP<SID>, ex - SAPHDB.

Querying the TABLES view would give the schema and table names and from there you can take it forward.

Hope it helps.