How do I delete sap* user ID when I forgot the password?

• Forgot Password for user id SAP* in client 000

  Happened to forgot your SAP* pasword in client 000 and you don't know what to do now. You need to log in to client 000 to apply support packages

  Options 1:

  Create the Program in any other Client and run it with SAP* User.
  It will set the SAP* Password same as in your current client.

  REPORT Z_SAP_USER_PASSWORD_SET.
  *
  * Run this progam as sap* in cient xxx. The user you specify
  * as a parameter, will have the same, client xxx password set in every
  * client
  * where it exists.
  *
  TABLES: USR02, T000.
  DATA: PASSWD LIKE USR02-BCODE.
  PARAMETERS: USER LIKE USR02-BNAME.

  SELECT SINGLE * FROM USR02 WHERE BNAME = USER.
  IF SY-UNAME <> 'SAP*'.
  WRITE: / 'Only SAP* is allowed to run this program'. EXIT.
  ENDIF.
  IF SY-SUBRC <> 0.
  WRITE: / USER, 'user does not exist!'. EXIT. "No template user
  ENDIF.
  PASSWD = USR02-BCODE.
  CLEAR USR02.
  WRITE: / 'The password of', USER, 'updated in client:'.
  SELECT * FROM T000 WHERE MANDT <> '066' AND MANDT <> SY-MANDT.
  SELECT * FROM USR02 CLIENT SPECIFIED WHERE MANDT = T000-MANDT AND
  BNAME = USER.
  WRITE: / USR02-MANDT.
  USR02-BCODE = PASSWD.
  USR02-LTIME = SY-UZEIT.
  USR02-BCDA1 = USR02-BCDA2 = USR02-BCDA3 = SY-DATUM.
  USR02-BCDA4 = USR02-BCDA5 = SY-DATUM.
  UPDATE USR02 CLIENT SPECIFIED.
  ENDSELECT.
  ENDSELECT.
  

  Options 2:
  You can logon as DDIC and change the SAP* password
  

  Options 3:

  You can also delete SAP* user in client 000. It will default its password to PASS.

  In SQL

  SELECT * FROM USR02 WHERE BNAME='SAP*' AND MANDT='000'

  Run query to check return. Change Select to Delete and run again.
  

  Options 4:
  Aren't you supposed to use DDIC to install hotpacks?

  However, some prefer to use other users besides ddic.
  

  How to reset ddic & sap* passowrds on client 000

  I install sapr3 4.7 and on WIN 2003& orale Db and after installation I set the the passwords for SAP* & DDIC on client 000 then I forget it. Pls help me how to reset them to login to the system by client 000& i in form u i can login with 001 & 066
  =====
  ## Rest the password of 'sap*' in client 000
  ## Log on to oracle database using sqlplus.
  sqlplus / nolog
  SQL>connect /as sysdba
  SQL>update .USR01 set bname='SAP*1' where bname='SAP*' and MANDT=000;

  ## [ e.g.: update SAPR3.USR01 set bname='SAP*1' where bname='SAP*' and MANDT=000; ]
  ## [e.g. : update SAP.USR01 set bname='SAP*1' where bname='SAP*' and MANDT=000;]

  SQL>commit;
  SQL>exit

  ## This will reset the user SAP* in client 000 . After loggin in client with user SAP* change the passwords for other users.

  ## You can user client number of your respective client.

  ## Please note do not reset any other user than SAP* with this method.

Continue Reading...