Skip to Content
avatar image
Former Member

DDIC Password reset

Hello All,

How can i reset password of DDIC user of client 000?

I don't have any other user id in same client.

Database MAX DB 7.5

Best regards

amol

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 02, 2012 at 08:58 AM

    Hi Amol,

    You need to set the profile parameter rdisp/login_no_sapstart = 0.

    Take SAP r3 restart.

    Later connect to SQL studio with schema user.

    run the following SQL commands

    SQL> select bname from usr02 where mandt='000' and bname='SAP*'

    If the user SAP* exists then delete the user with below command

    SQL> delete from user02 where mandt='000' and bname='SAP*'

    Run the below command to verify whether user deletion was successful.

    SQL> select bname from usr02 where mandt='000' and bname='SAP*'

    Later login to client 000 with SAP* and password as pass

    reset the password for user DDIC with SAP* user.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Deepak Kori

      Hello Deepak,

      Can you please tell me with which password i have to use to login SAP<SID>,

      I tried Installation MASTER password but it is not working,

      There must be another password for same.

      If i change the password as per the note 25591 my instance get crashed.

      please tell me if you have any idea