11 Replies Latest reply: Mar 7, 2012 9:28 AM by Amol Dounde RSS

DDIC Password reset

Amol Dounde
Currently Being Moderated

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

  • Re: DDIC Password reset
    Deepak Kori
    Currently Being Moderated

    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

    • Re: DDIC Password reset
      Amol Dounde
      Currently Being Moderated

      Hi Deepak,

       

      i have executed cmd as you have mentioned but its fetching below error

       

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

       

      Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

      Base table not found;-4004 POS(19) Unknown table name:USR02

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

      • Re: DDIC Password reset
        Rajesh Narkhede
        Currently Being Moderated

        Please try...

         

        select bname from sap<sid>.usr02 where mandt='000' and bname='SAP*'

         

        OR

         

        select bname from SAPSR3.USR02 where mandt='000' and bname='SAP*'

         

         

        Regards.

         

        Rajesh Narkhede

        • Re: DDIC Password reset
          Amol Dounde
          Currently Being Moderated

          Hello Rajesh,

           

          I have executed cmd as you have mentioned but helpless

           

           

          --- Error -


          Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

          Base table not found;-4004 POS(19) Unknown table name:USR02

          select bname from sapshp.usr02 where mandt='000' and bname='SAP*'

          • Re: DDIC Password reset
            Rajesh Narkhede
            Currently Being Moderated

            Hello,

             

            Typically the tablename would be SAPSCHEMA.USR02

             

            Check your schema name and use it in SQL query..

             

            I am not sure, but check if the name is case sensitive.

             

            Regards.

             

            Rajesh Narkhede

            • Re: DDIC Password reset
              Amol Dounde
              Currently Being Moderated

              hello,

               

              i have connected to database with superdba with pwd admin cause it is not allowing me to login from other user

               

              then i have entered query as below

               

              delete from sapr3.shd where bname='SAP*' and mandt='000'

               

              but its is showing that

               

              --- Error

              Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

              Base table not found;-4004 POS(19) Unknown table name:USR02

              select bname from sapshp.usr02 where mandt='000' and bname='SAP*'

               

               

              please help

               

              best regards

               

              Amol

              • Re: DDIC Password reset
                Ivy Toh
                Currently Being Moderated

                Hi Amol,

                 

                Please connect as user SAP<sid> user instead of superdba.

                 

                Cheers,

                Ivy

                • Re: DDIC Password reset
                  Amol Dounde
                  Currently Being Moderated

                  hello Ivy,

                   

                  I tried to login with SAPSID  but there is error message regarding ODBC drivers & userid & password does not match

                   

                  Regards

                  Amol

                  • Re: DDIC Password reset
                    Amol Dounde
                    Currently Being Moderated

                    Hello Guys,

                     

                    for login SAPSID i have changed the password of SAPSID from SUPERDBA user but it leads into the instance down cause of

                    the database get disconncted from SAP application

                     

                    please help

                    • Re: DDIC Password reset
                      Deepak Kori
                      Currently Being Moderated

                      Hi Amol,

                       

                      In MaxDB Version 7.5 and higher you can use the "SQLStudio" or the command

                      line tool "sqlcli" to run the SQL statement, if you are logged on to the OS

                      as <sid>adm or user in the group sdba:

                       

                      sqlcli -d <Database name> -u sap<sid>,<Password>

                      <enter>

                      "delete from usr02 where mandt='<Client>' and bname='SAP*'"

                       

                      You could run this SQL statement as schema user - SAP<SID> or SAPR3

                      After you delete the user in the Database level, please restart the

                      Application server and you can then logon to the system again with

                      the SAP* user and the password PASS.

                      Please see the SAP note 2383 for description of "super user" SAP*!!

                      Create a super user, allocate it to the SUPER group, and assign it the

                      SAP_ALL or S_A.SYSTEM authorization profile.

                      Then maintain the SAP* user and assign it a password.

                       

                      Hint:

                      It is sufficient to temporarily set the login/no_automatic_user_sapstar

                      parameter to the value 0 on the application server < SAP note 68048>.

                      This application server should be restarted after the value of the profile

                      parameter was changed.

                      And you try to log on to this application server as user 000/SAP*/PASS.

                      SAP strongly recommends that you reset the profile parameter login/no_automatic_user_sapstar to value 1 afterwards.

                       

                       

                      Regards,

                      Deepak Kori

                      • Re: DDIC Password reset
                        Amol Dounde
                        Currently Being Moderated

                        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

Actions