How can one unlock these users from command prompt?

You can unlock user from os level. All user informations are stored in table USR02. If u want to unlock the user set the field UFLAG to zero.

how can i set UFLAG field to zero

Hi Friends,
 
Can anyone reply to what has been asked. I have got 2 clients in 000 SAP* & DDic. Both are locked. How do i unlock them? Your immediate help will  be appreciated.

Hi,
 
You can delete the password value from USR02 table from the SQL prompt. Please read some more on Basis Admin and don`t ask interview questions in this group.

�f you can access to database for
example with sql*plus for oracle

Update table usr02 -> field UFLAG set
it to 0 manually.

This will help.

I am not giving you the exact SQL sentence
since it differs depending on RDBMS.

!!!!!!!!!!!!!!!!!

Again BE CAREFULL about the WHERE CLAUSE.
DO NOT SET TO ALL USERS!!!!!!

!!!!!!!!!!!!!!!!!

Becarefull about the client.

�f you remove SAP* from the table
than the default password can be used.

SAP* is hardcoded in the system.

If you only want to unlock the users set the "UFLAG" to 0 in the "USR02" Table
make sure you set the corrent user in the correct client (by checking MANDT field in the same table)
 
exp. UPDATE SAPR3.USR02 SET UFLAG=0 WHERE MANDT=000 AND BNAME=DDIC

Try one of  this

1. Login at database level and set uflag to zero with following command

update .usr02 set uflag = 0 where mndt = and bname = ;

Then commit the above change by following command -

commit;

2.Login at database level and delete sap* user from usr02 table with following command

delete from .usr02 where mndt = and bname = ;

Then commit the above change by following command.

commit;

This will reactivate your sap* kernel user and you can login with sap* and password pass.

This is not an interview question for your kind information. This has happened on my PROD server unfortunately. And if you dont wish to Answer keep your mouth shut and dont reply. Dont give me such replies. Give SOLUTIONS and not COMMENTS.

I’m with you, I think Manish’s
been harsh on you and his comments didn’t make sense anyway!

Don’t worry, you can ask anything in
this group related to SAP of-course.

Cheers & have a nice weekend

I was not being harsh on Rahul. Don`t take it otherwise Rahul or anybody else. I just want that people should search on the topics first thoroughly, by doing that they will got a lot of information related to other topics which will help them in future. I also made mistakes like these in past and after getting these kind of mails for myself, I started searching on net and got lot of material and help from there.

As you know Necessity is the mother of invention.
Just like that before posting any question people should search on net. There is lot of material available, just a little will required to search that.

Totally agreed, however remember that we’re
all beginners once before and should help those in needs without questioning
what they’ve done or not.  If everyone just withhold solutions then
this forum is of no good.  I think it’s easier to give answers then
to interrogate their effort in searching the net.  Anyway that’s my
opinion & sorry for wasting others time in reading my crap.