This article answers the following queries:
- Forgot sap login password for ABAP stack . Donot have any other password for any other user id. How to login to sap?
- How to activate automatic sap* user in ABAP stack of SAP?
- Unable to login to newly created client with sap* and default password. How to login now ?
- Sap* user got locked for ABAP stack. Donot have any other user id to unlock the same. How to login to system again?
---------------------------------------------------------------------------------------------
In
SAP, there is a parameter login/no_automatic_user_sapstar whose default
value is 1. If the value is set to 1, automatic login of sap* into SAP
system using password PASS won’t be allowed.
In all of the above scenarios,
Pls
set the value of parameter login/no_automatic_user_sapstar to 0 in both
the default profile and the instance profile and restart the instance.
So automatic login of sap* with default password will be enabled.
Afterwards, connect to the database and execute the following command :
In the following example am considering, oracle as the database.
sqlplus “/ as sysdba”
SQL > Delete from SAPSR3.USR02 where MANDT=’000’ and BNAME=’SAP*’;
In
the above command, SAPSR3 is the schema of the database and USR02 is
the table name and MANDT is the client and BNAME is the user id.
In case you would like to activate sap* in client 500 and your schema name is SAPBPW then the command would be as below :
SQL > Delete from SAPBPW.USR02 where MANDT=’500’ and BNAME=’SAP*’;
Once you successfully executed this command, you can login to sap system with SAP* user id and default password PASS
0 Comments