Friday, August 8, 2014

Password reset of SAP user in Max DB

It happened to me that right after I installed trail version of SAP NetWeaver ABAP Application Server 7.03 I immediately forgot what was password I set for my user. I tried enter some passwords that were popping up in my mind but I locked that user. I could not enter the password anymore as account go locked due to too many unsuccessful attempts. Therefore I had to unlock the user first before I reset the password.

I used Max DB SQL Studio to reset it. Here's UPDATE SQL statement:

UPDATE  SAPNWG.USR02
  SET uflag = '0' 
    WHERE bname = 'BCUSER'













PS: No MANDT specification in WHERE clause needed as there was only one user across all clients with that name.


No comments: