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 acessible

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

2) SQL Command to show schema used