Wednesday, August 13, 2008

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...
 

+dimanaanakku+ Copyleft © 2009 AllFight Deserved | WoodMag is Designed by Ipietoon and Modified by Yafet St. OfGod