Sunday, 28 September 2014

How to Reset "ddic" Password with SAP*

How to Reset "ddic" Password with SAP*


Scenario:

You have forgotten the ddic password on client:000 during patch activity and do not have any other login to reset the password.

The solution is to use the default "SAP*" user to reset the password


Steps:


1) Login to any other client -> execute TCODE: RZ10 -> change the parameter: "
login/no_automatic_user_sapstar =0"  (this is to allow "SAP*" to access the system)



2) Save and activate the profile



3) Restart the SAP services

4) Now login into the client:000 with user: "SAP*" and password: "pass"-> execute TCODE: SU01 -> Reset the "ddic" password


5) Repeat the same step as step 1 and 2 by changing the "
login/no_automatic_user_sapstar =1" (to disable "SAP*" access to system)


6) Restart the SAP services

7) System is secure and "SAP*" no longer accessible




Others:
1) SQL command to check whether "SAP*" exist in table: USR02

SQL>Select * from SAPSR3.USR02 where bname ='SAP*' and mandt='000';




No comments:

Post a Comment