// ]]>

Friday, 21 March 2014

How to activate automatic sap* user in ABAP stack of sap?

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.

How to change SAP parameter ?

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

Login to 000 with DDIC with password - 19920706.
Run SU01.
Edit sap*
Assign SAP_ALL & SAP_NEW profiles to it.

Save it & prob resolved.