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

[Former Member]

Hi,

after providing the above sql statemnet , did it gave the message as "one row updated"?

if not your sql statement has not executed.

you can delete sap* at OS level from sqlplus using below sql statement and then you can unlock and reset your user at ABAP end using newly created sap* user with password pass.

sqlplus> delete from <schema>.usr02 where bname='sap*' and mandt=<CLNT>;

Regards,

Venkata S Pagolu

[Former Member]

thanks i khow this solution but for this you have restart the sap instace via changing the parameter in sap profile.

and after exective this command 1 row updated message had come after that i commit.

any other method with out restart sap instance.

[Former Member]

Hi,

I think there is no any other option from OS level to reset the password for SAP user. Only thing is to contact your SAP security admin and get the password reset for your user.

Regards,

Venkata S Pagolu