Skip to Content
author's profile photo Former Member
Former Member

Reset SAP* password

Hi All,

We have need to reset the SAP* password because SAP* (also DDIC) is locked on client 000 and we don't have any other user. We are on MAXDB (we have also SQL Studio) so we have the error "table unknown" when we try to excute the statement SELECT * FROM USR02 or SELECT * FROM SAPECP.USR02, where SAPECP is the owner. Obviously we want to excute the statement DELETE FROM USR02 WHERE BNAME='SAP*' AND MANDT='000'.

How can we proceed on MAXDB?

Reagards

Bob

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 30, 2007 at 11:58 AM

    As which user are you connecting with the SQLStudio?

    --

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      look at following forum

      sap-password-reset-query-in-maxdb

      -


      Please see the SAP notes 68048 and 2383.

      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,

      kaushal

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.