Whenever SAP* user got locked (mainly in 000 Client), in most cases we are supposed to unlock the SAP* User in database level.
Before logging into SAP system using SAP* user, be aware whether the parameter login/no_automatic_user_sapstar is set to value 0 (Zero).
If the value of parameter login/no_automatic_user_sapstar is set to 1, it will not allow the SAP* user to login to the SAP system.
Steps to Unlock the SAP* user (DB level)
1. Try login SAP system with SAP* user
SAP* user got locked due to too many attempts with wrong password.
2. Login to Ms SQL Database,
3. Execute the query:
select * from er1.USR02
The status of the user is locked/Not locked is identified in the field UFLAG.
In the above screenshot, value of UFLAG is 128 for the user SAP*, means the SAP* user got locked.
Note : If the value of UFLAG results in a Non-Zero value, then it means that the user got locked.
4. Execute the query:
select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’ to find the details of only SAP* user.
For Unlocking the user, the value of UFLAG should be set to 0 (Zero).
5. Execute the query:
update er1.USR02 set UFLAG=‘0’ where BNAME=‘SAP*’ and MANDT=‘000’
6. Now execute the query :
select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’
Now the Value of UFLAG has been altered to 0.
SAP* user has been unlocked.
==========================================================
Hi Dino,
Nice document. Very detailed!
Regards,
Eduardo
Thanks a Lot Eduardo Rezende 🙂
Warm Regards,
Dino
Hi
Good one 😎
Thanks
Ram
Bookmarked and liked !
thanks Dino, you did a grate Job 😉
kindly confirm if i follow the above procedure do i need to restart the system.
Hi Aravind,
No need to restart the system.
thanks gaurav
Thanks for sharing the procedure
eXcellent documentation, thanks a lot.
Can any1 explain for Oracle database in Windows environment..???
Regards,
Javed
Hi Javed, you should seek similar information in the following space:
SAP on Oracle
I don’t work with Oracle but it seems to me that the tables are the same, so you would need to use sqlplus or other Oracle tool to connect to DB.
Google it, Ive done it tons of times on Oracle, its very common on many sites.
Thanks Dino, this was really helpful.