Pages

Thursday, April 8, 2010

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 comments:

  1. the delete cmd whcih u hav mentioned is deleting the sap* user account..

    ReplyDelete
  2. Delete Useraccount is no Problem. If sap* deleted it use the Hardcoded Password "PASS"

    ReplyDelete