Administrator user locked in 000 client

[Former Member]

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.

[Former Member]

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.

[Bernhard_SAP]

Hello,

the standard way yould be teh SAP* procedure, which you have found already.

b.rgds, Bernhard

[Former Member]

Hello,

If you can now remember admin user password, you can Unlock your admin user by SQLs. If not, then i think only possibility is SAP*.

Check below threads :

thanks

ashish

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Ashish,

Thanks for your inputs. Issue got resolved.

Durga.