Skip to Content
avatar image
Former Member

Unable to login with UserId SAP* nor DDIC onto client 000.

Hi,

I'm trying to login to 000 client with SAP* userId and default password. but it does not take it.

Later I logged in the Database Oracle level, as SysDBA & executed the SQL Statement

DELETE FROM SAP<sid>.USR02 WHERE MANDT=’000’ AND BNAME=’SAP*’ ;

but this shows "0 rows deleted"

this same worked in another SAP system.

Running this SQL statement resets SAP* password to the default.

Please Guide.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 02, 2007 at 07:14 AM

    Hello Anil,

    Execute the query and check if you are able to fetch the record

    Select BNAME, MANDT, BCODE from SAP<SID> where BNAME='SAP*' and MANDT='000';

    if yes, then execute the DELETE query again.

    If not then, maybe the record has already been deleted by one of your query.

    Have you tried login to client 000 with SAP* as password PASS?

    Regards,

    Ammey Kesarkar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2007 at 06:54 AM

    Hi Anil,

    try to execute this query..

    <i>delete from <HOSTNAME>.<SID>.<object_owner>.USR02 where BNAME='SAP*' and MANDT='000';</i>

    after this bring down the instance and restart. then SAP will re-create SAP* userid and with default password "PASS" (case sensitive).

    hope this info helps you!

    with regards,

    raj.

    <i>pls, award points</i>

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello everyone,

      I do have a similar problem.

      Lately have installed SAPNetweaver2004s with an Oracle 10.2 DB.

      As I wanted to perform a Client Copy, I am not able to Logon with the common default passwords to the new Client 100, wether with sap* nor ddic.

      Can i use also the same query

      delete from <HOSTNAME>.<SID>.<object_owner>.USR02 where BNAME='SAP*' and MANDT='000';

      to be able, to logon to Client 100? What other chaces do i have, to logon to Client 100?

      And one last question: What "<object_owner>" stans for?

      I hope, somone can help me

      Best regards

      Franz

  • avatar image
    Former Member
    Feb 02, 2007 at 07:10 AM

    before deleting execute

    select BNAME from SAP<SID>.USR02 where MANDT='000';

    check wether user SAP* exist in the system may be some other person might have deleted the user

    if it is so check the perameter no automatic user sapstar in profile wheter it is 0 or not if it is 1 change to 0 and restart the serever and login to client with user SAP* and password pass

    Samrat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2007 at 08:53 PM

    Hi All

    If you are authorized to use T code SU01 first check the user sap* and DDIC as well and try to delete the SAP.If you are able to delete the SAP you can now be able to loginto sap* with password pass.Please do try with sap* as user and 06071992 as password it may work some time.

    Regards...

    S.Manu.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2007 at 03:00 AM

    Hi Anil,

    When you installed these SAP systems, I believe that you are entering new password for SAP* dan DDIC user. Both of this user, by default, on client 000 are using password you are entering during installation.

    Try to remember and look for your installation screenshot.

    Hope that can help you.

    ardhian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anil,

      if you need to login with SAP* and password pass you need to set the instance parameter:

      login/no_automatic_user_sapstar=0

      after restart the instance.

      Mario

  • avatar image
    Former Member
    Apr 11, 2007 at 04:33 AM

    Rajesh's answer was useful.

    Add comment
    10|10000 characters needed characters exceeded