Activating Automatic sap* user

How to activate automatic user SAP* in ABAP stack?

Concept

Generally, you should use the user SAP* when you forgot your SAP login password or you do not have access to any SAP Account.
This user has full authorizations, since no authorization checks are performed.

In SAP, the profile parameter login/no_automatic_user_sapstar allows you to activate or deactivate these special properties of SAP*.
0: Automatic user SAP* is permissible
1: Automatic user SAP* is deactivated

By default, the parameter login/no_automatic_user_sapstar is set to 1, which mean that automatic login with SAP* into SAP system won’t be allowed.
In order to login with SAP*, set the value of parameter login/no_automatic_user_sapstar to 0 and restart the instance.

Procedure

By default, the password of the user SAP* should be the master password.
If you do not remember this password or it changed, you have to delete the user master record of the user SAP* in the database, so it will be possible to log on with SAP* and the initial password PASS.

Connect to the database (in Oracle Database)
# sqlplus "/ as sysdba"

Execute the following command (in Oracle Database):
SQL > Delete from SAPSR3.USR02 where MANDT='000' and BNAME='SAP*';

Note:
In the above command, SAPSR3 is the schema of the database; MANDT is the client and BNAME is the user ID.
In case you would like to activate SAP* in client 120 and your schema name is SAPERP, then the command would be as below:
SQL > Delete from SAPERP.USR02 where MANDT='120' and BNAME='SAP*';
Once you successfully executed this command, you can login to SAP system with SAP* and default password PASS.

Note:
SAP parameter can be set using RZ10 transaction or directly in the SAP profile instance.

Execute the transaction RZ10
Select the respective instance profile of the application server on which you would like to change the parameter

From the dropdown of profile, select the instance profile (of the application server) on which you would like to change the parameter

After selecting the profile, select extended maintenance button and press change push button

It displays a screen with all the parameters as shown below :

You can  either search the parameter or create the parameter and then set the value to the desired and save the same as below.

Set the parameter value in the text box provided and click copy button to copy the same and then press back button and press copy again in the next screen. After that press the back arrow to come to the following screen

Click on Save button to save and activate the profile.

Press no to goto the next screen



Press yes, to activate the profile.



The parameter will take effect after restart of the application server


Log on on the SAP system with the SAP* user

Share this

Unknown