Unlocking SAP* in ABAP if no other user exists or locked
Reason: If all the administrative users are locked and if no other user has access then you have to unlock SAP* to be able to login to SAP.
Solution:
First insert the following parameter in Instance Profile:
login/no_automatic_user_sapstar = 0
Restart SAP Only.
Then login to Oracle and execute the following commands:
SQL> Delete from
SQL> Commit;
Note: Please substitute mandt=*** with the client number and
Example: So the command would look like this if SAPSHEMA is SAPSR3 and Client you want to unlock SAP* is 400
SQL> Delete from sapsr3.usr02 where bname = 'SAP*' and mandt = '400';
2 Response to "Unlocking SAP* in ABAP if no other user exists or locked"
Post a Comment