04-13-2011 9:55 AM
Hello all,
We have our own user adminstrator login in 000 client and it got locked by me due to too many failed attempts. This activity happened during my pre-checks of SP upgradation. I am able to login into 900 client as well but bot into the 000 client.
I even don't know the passwords for SAP* and DDIC in 000 client. Now my requirement is to unlock my own adminstrator login in 000 client without touching / resetting SAP* and DDIC passwords.
I have searched many forums, all of them are pointing towards resetting of SAP* and DDIC passwords from SQL prompt.
Is there an alternative suggestion to unlock admin login in 000 client. Your help is highly appreciated.
Rgds,
Durga.
04-13-2011 10:22 AM
Just one addition on SAP* method : Complete restart of system is not required. You can do this with restart of any one application server only and changing parameters there.
04-13-2011 10:10 AM
Hello,
the standard way yould be teh SAP* procedure, which you have found already.
b.rgds, Bernhard
04-13-2011 10:19 AM
04-13-2011 10:22 AM
Just one addition on SAP* method : Complete restart of system is not required. You can do this with restart of any one application server only and changing parameters there.
04-13-2011 11:29 AM
Hello Ashish,
Thanks for the update.
I would like to unlock administrator login by using uflag option like below from sql prompt:
<SQL> update sapACB.usr02 set uflag=0 where mandt='000' and bname like 'SUPER';
from the above statement, ACB is my SID and locked login name is SUPER. Please correct my above statement if anything wrong whether i need to provide SID or complete schema name?
Rgds
Durga.
04-13-2011 11:48 AM
Hi Durga,
First do a select query on USR02 and then update(followed by commit).
select * from sapABC.usr02 where mandt='000' and bname='SUPER' ;
You need to provide your complete schema name before table. You can get this using DB02old > Details Analysis > USR02 as Object name > Owner.
Why not do this in Dev system for checking SQLs.. Owner may be different.
thanks
ashish
04-13-2011 12:30 PM