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 .usr02 where bname = 'SAP*' and mandt = '***';
SQL> Commit;

Note: Please substitute mandt=*** with the client number and with actual schema.
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"

  1. Anonymous August 21, 2012 at 9:15 AM
    the delete cmd whcih u hav mentioned is deleting the sap* user account..
  2. Anonymous February 10, 2015 at 10:33 AM
    Delete Useraccount is no Problem. If sap* deleted it use the Hardcoded Password "PASS"

Post a Comment