on 09-08-2010 12:41 AM
Dear all,
I have created a new client 100 as a copy of client 001 in a fresh installation and am unable to logon to it with user sap, ddic or admin user in client 001. I have tried deleting sap from the new client 100 to enable access wtih default password but sap* does not appear to exist in the db schema.
The db schema in use is SAPSR4. The parameter is also set as below.
login/no_automatic_user_sapstar = 0
The SQL used is:
SQL> DELETE SAPSR4.USR02 WHERE MANDT='100' AND BNAME='SAP*';
Please advise.
Regards.
Hi,
> The db schema in use is SAPSR4. The parameter is also set as below.
> login/no_automatic_user_sapstar = 0
ok, check your profile parameter in RZ11 for the current value in
the running system. If it is 1, you need to restart as said before.
> The SQL used is:
> SQL> DELETE SAPSR4.USR02 WHERE MANDT='100' AND BNAME='SAP*';
... and you did a COMMIT in addition, did you ?
The reason then can be, that table USR02 is bufferd inside SAP.
If you already tried a login before the delete on db-level the old record might still be buffered.
Login to another client and execute $TAB as a transaction code.
This resets the table buffer (should not be done during high activity).
Open a new gui and try again.
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I hope u have not restarted the SAP instance after setting the parameter. If yes, restart the SAP instance and then try to login with the default password.
Hope this will resolve ur issue.
Regards,
Varadharajan M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohammed,
Can you tell me what are all the profiles (SAP_CUST,SAP_USER etc) you have used during client copy??
Thanks,
Jagadish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohammad,
Your Parameter seems to be ok... and your SQL statement is missing from clause..
The SQL used is:
SQL> DELETE SAPSR4.USR02 WHERE MANDT='100' AND BNAME='SAP*';
The correct statement should be like....
Delete from sapsr4.usr02 where bname='SAP*' and mandt='NNN'; (NNN=Your client)
Arguments in quotes are case sentitive...If you get an output like "1 record deleted", type commit;
All the best !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.