Skip to Content
avatar image
Former Member

How to recreate SAP* user master record in a client

Hi..

Due to some urgency, we have deleted SAP* from database(Oracle) using command-

delete from SAPPRD.USR02 where BNAME='SAP*' and MANDT='500';

Now after deleting SAP*, i need to login with password while parameter "login/no_automatic_user_sapstar=1" is set.

Because user master record does not exist for client 500, I am unable to login with user SAP*.

I also tried to recreate user SAP* using SU01 but it result to ABAP dump with message--

"The ABAP/4 Open SQL array insert results in duplicate database records."

Regards

abhimanyu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Apr 05, 2010 at 12:09 PM

    Hello Abhi

    lmake ogin/no_automatic_user_sapstar=0 and restart the application server.

    Now, you should be able to login with SAP* and user "pass"

    also look at thread below

    sap* login password change

    Regards

    Anindya

    Edited by: Anindya Bose on Apr 5, 2010 5:42 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Anindya Bose

      Hi..

      No help with these steps. still program in SU01 is terminating.

      one thing, can record directly be inserted in USR02 table for SAP*. and then can be tried with SU01 ????

      Regards,

      Abhimanyu

  • avatar image
    Former Member
    Apr 09, 2010 at 09:49 AM
    i need to login with password while parameter "login/no_automatic_user_sapstar=1" is set.
    I want to use specific password without changing parameter login/no_automatic_user_sapstar.
    
    I don't want to use default passord PASS after changing parameter login/no_automatic_user_sapstar

    Can you tell us the reason behind this? why you want to run SAP in your way and why don't you run with.

    Once you deleted sap* user, it will be taken care by sap automaticaly..you cant do anything(as a customer) otherthan changing the parameter and logging with initial password pass........

    1) change the parameter value to 0

    2) delete sap* from DB level

    3) login with sap* and password pass

    4) you can create user master record from SU01

    Just follow the steps and update this message with output....

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi..

      I was getting error in step 4. so i just created a dummy user "TEST" and then used following command to update it to "SAP*"

      update SAPPRD.USR02 set bname = 'SAP*' where mandt = '500' and bname = 'TEST';

      commit;

      Now i am able to login with SAP* in client 500 and now working OK.

  • avatar image
    Former Member
    Apr 09, 2010 at 10:10 AM

    Solved myself,

    see last post for solution.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2011 at 10:13 PM

    Hi , Sorry to revive an old thread but this is the closest problem I could find related to what I am going through now.

    I completed a refresh of a system from a different system and I now need to login to the new target system but I don't have ANY login information.

    I logged into the DB via sql and deleted the sap* entry and committed the changes but the default password is still not working. I executed these statements:

    SQL> DELETE from SAPBIX.USR02 where MANDT='000' and BNAME='SAP*';

    1 row deleted.

    SQL> commit;

    Commit complete.

    I suspect the parameter login/no_automatic_user_sapstar is set to 1 so this type of access is forbidden. But I am in a situation where I don't know any username/password to login to the system to have this parameter reset... Is there any fail-safe for a situation like this? Any help appreciated!

    Kindly,

    Omar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2014 at 05:00 PM

    user SAP* is stored in more than one table. To completely eliminate the duplicate exist error when trying to recreate the SAP* ensure that it delete from all the tables listed by using

    DELETE  FROM SWP.swp.<tablenme>   where MANDT =<clientID> and BNAME='SAP*'

    USR01

    USR02

    USR03

    USR05

    USR07

    USR21

    USR21S

    USR22

    USR41_MLD

    USRBF2

    USRBF3

    USREFUS

    Regards,

    Adeyinka

    Add comment
    10|10000 characters needed characters exceeded