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.
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
17 comments:
In IDES 4.7 I deleted sap* user from client"000" using su01 and then tried to login with sap* and password-->"06071992",I couldn't login. so I tried to login this time with password as "pass" and it worked.Then I created sap* user again in the same client(000) and set the password as "06071992",I was able to login but I am not able to run any of the t-codes as i am getting the error that sap* is not authorized to run this transaction. Can you help me out with this ?
Login to 000 with DDIC with password - 19920706.
Run SU01.
Edit sap*
Assign SAP_ALL & SAP_NEW profiles to it.
Save it & prob resolved.
hi durgaprasad,
i installed ECC6.0 and sap in C drive and oracle in G drive and , sap is working properly , but i am unable to connect with database at os level, please tell me, database sid is yuv
Thanks and regards,
malleshera@gmail.com
Do we need to bounce the system after we change the parameter?
hello prasad,
i was unable to login to 000 client with user sap* and ddic, i forgot the password. and i was unable to login to sap* in client 001 but i was able to login into 000 and 001 with user ddic
Hi..Please follow the recommendations mentioned in the above article. You will be able to login with sap* with pass password.
Hi Satadru, If the parameter is dynamic, no need to bounce. if the parameter you changed is static one, you need to bounce the system for the parameter to take effect.
Hi Mallesh,
Please let us know the error you are facing so that it would be possible for me to understand the issue.
Just need to set the parameter as 1, so which profile i need to select, is it default in RZ10
how to delete sap* in os level pls tell me
how can i change these parameter on os level.. i have windows 10
durga prasad ji,
i am created one new client. but i am trying to login
username : sap*
password : pass
but i am getting wrong username and password ... will u clarify my problem
Hi...
When i try to delete sap* user by using MANDT=000 it is showing like 0 rows updated and 000 client is not visible in existing clients list.
My database is Oracle 12c. Any solution for that...??
Hi Durgaprasad ,
If i change the parameter for sap* login is that manditory to delte the usr02
in the login level ??
After setting paramer I was able to login with sap* password . But I couldn't see user neither in Usr02 nor su01 .. can someone explain how we are able to login to system without maintaining the user master record in Usr02 .. and please explain how user is storing in kernal level (as hard coded value)
These topics are very helpful for the beginners and kindly try to upload recent activities if possible this will helpful....
Post a Comment