on 05-09-2007 1:11 AM
I have lost the password for SAP* and DDIC in client 000.
I tried to manually delete the user SAP* from the Table USR02 for the client 000.
After that I try to log in as SAP* and use the default password as "PASS"
It still gives me error as "User is locked. Please notify the person responsible".
Any idea what to do next?
Thanks a lot.
Amy
HI amy,
First check whether the uflag is set to 64 for sap* at table level. You can use SE16 and check the entries in table USR02.
uflag =64 is locked
uflag =0 is unlocked
If SAP* uflag is 64, then you can change the settings at DB level.
1. Login to DB and at command prompt
2. use the statement
Select sapr3.usr02 where mandt=`<clnt.no>` and bname=`sap*`;
3. if the uflag is 64 then change to 0
update sapr3.usr02 set uflag=`0` where mandt=`<clnt.no>` and bname=`sap*` ;
commit work;
4. use the step 2 select statement to check whether the uflag for sap* is changed to 0.
5.Now login to SAP using SAP* with default password `PASS`.
regards,
Vinodh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vinodh,
Thanks a lot for reply back. Actually I did all these before I send email out. The main reason it didn't work is because the buffer was not updated. So, I restarted the system, and wahla....... it worked as it says it would.
Thank you anyway for trying to clear it out for me, and giving me tips on what to look.
Amy
And everyone who respond trying help me.......... Thank you all!!!
Hi
Check the parameter login/no_automatic_user_sapstar= 0
Thanks
Pankaj Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi amy,
If all the users are locked, they can be unlocked by
a) GO to command prompt type tp unlocksys <SID> pf=//usr/sap/trans/bin/TP_DOMAIN_<SID>.pfl;
b) or else try this command at ur sql plus query level
Go to cmd prompt.
Sqlplus /nolog
conn /as sysdba
this will take you to the sqlprompt.
Just execute the earlier commands there.
sqlplus>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64;
this statement actually unlocks the users of that particular client. So, try for every client in that sap system.
c) You can delete sap*
Go to cmd prompt.
Sqlplus /nolog
conn /as sysdba
sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;
<u><b>Note:-</b></u>
After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).
regards,
kanthi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
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.