Showing posts with label sapschema. Show all posts
Showing posts with label sapschema. Show all posts

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';