on 02-02-2007 6:48 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rajesh's answer was useful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.