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.
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.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment