Showing posts with label MaxDB. Show all posts
Showing posts with label MaxDB. Show all posts

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.