Skip to Content
avatar image
Former Member

Sap* and DDIC user login issue

Hello,

I forgot the SAP* and DDIC password in 001 client. I donot have any other user to login into 001 client.

But I can login into 000 client.

How to reset the password in 001 client ?.

Thanks

Thirumal.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 09:15 AM

    Dear Thiru,

    You got to deletre SAP* from the database

    Proceed as follows:

    1.Check your instant profile and make login/no_automatic_user_sapstar is set to "0" and now make a restart of your server.

    Try this from command prompt.

    sqlplus /nolog;

    conn /as sysdba;

    Now type this and take caution as this is case sensitive:

    DELETE FROM <sid>.USR02

    WHERE BNAME='SAP*' AND MANDT='<client no.>'

    EG-->

    DELETE FROM dev.USR02

    WHERE BNAME='SAP*' AND MANDT='001'

    Then restart your server and login as user SAP* password pass.

    Hopefully this will work.

    Regards,

    Ashutosh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 09:14 AM

    no way you can reset password of SAP* and ddic of 001 client fromm 000 client

    option avaible with you is to delete sap* of 001 client using sql statements from DB level

    Samrat

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Tom Cenens

      Hi Ashutosh/Tom,

      Thank you very much for your brief information abt the issue. Its really helped me to fix the issue very shortly... ..

      Now i am anble to login into the Client 001 ..

      Thanks

      Thirumal.