cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (5)

Answers (5)

Former Member
0 Kudos

Rajesh's answer was useful.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

manu_susankar
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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>

Former Member
0 Kudos

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