Unlock user id via sql(oracle) command

[#1]

Hi experts,

I update the uflag in usr02 table oracle command to unlock the user in ecc 6.0

Update sapsr3.usr02 set uflag=0 where mandt=200 and bname='vivek'

commit

but login not possible.

if there is any method to unlock user via OS  and database level.

Ecc 6.0

Oracle 10g on RHEL 5.3

Regards,

Vivek

[JPReyes]

Instead of,

Update sapsr3.usr02 set uflag=0 where mandt=200 and bname='vivek'

Use

update SAPSR3.USR02 set uflag='0' where bname='VIVEK' and mandt=200;

I just tested that and worked fine, that should unlock your user

Regards

Juan

[Former Member]

Thanks Juan,

after unlock via this sql command try to login this user.

i m sure you can't login.

[JPReyes]

I can, I already test it, check your sql statement and try again.

Regards, Juan

[Former Member]

Hi Vivek,

Juan can login because the statement is correct.

Your problem may be, that your user was not locked "manually" (SU01 or SU10) but by too many failed logon attempts. As far as I remember, this method won't work then.

If you have time, you may trace SQL statements on Oracle level and lock another user with "failed logon attempts" - then you should see which tables are involved and which updates were issued.

If you are the SAP basis administrator, get in via parameter / restart / SAP* deletion, create SAP* again, then create an authorized administration user and store the complex password in a safe place (for emergency cases like this).

If you are not the SAP basis administrator, I would ask you to contact the admin to unlock your user.

Regards, Peter