Showing results for 
Search instead for 
Did you mean: 

Need access to SAP* but login/no_automatic_user_sapstar=1

Former Member
0 Kudos

Hi I completed a refresh of a system from a backup of another system but I need to be able to log in now via sap. I deleted the sap entry in the DB but I cannot log into my system with the default password PASS. I suspect the parameter login/no_automatic_user_sapstar=1. Is there a way I can log in to the system still (I don't have any other credentials to log into the system and change the parameter).

I executed these statements:

SQL> DELETE from SAPBIX.USR02 where MANDT='000' and BNAME='SAP*';

1 row deleted.

SQL> commit;

Commit complete.


But I cannot login the application layer, I am getting "Name of password is incorrect (repeat logon)"

Is there any type of fail-safe for a situation like this?



Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

> Is there any type of fail-safe for a situation like this?

Open the instance profile with a text editor, add

login/no_automatic_user_sapstar = 0

to the bottom, save the file and restart the instance. Then you can logon with SAP*.


Former Member
0 Kudos

thank you very much. it worked.