Enable deactivated productiove password from the backend

Hi Experts,

Does any one know how to enable deactivated productive password from the back end. The scenario is administrator him self not logged in continuously for 90 days and the login/max_idle_productive is set to 90 days and login/password_expiration_time set to 60days and the productive password got deactivated.

We can do this by deleting sap* and relogin sap* and reset the password. But I want to know how to do from the backend.

I tried this.

updated schemaname.usr02

set pwdstate=0 where bname='XXXX' and mandt='000';

commit,

But this didn't work. I know the id is not locked. Thatswhy I didn't set uflag to 0.

Appreciate if anyone could help on this?

Thank you

Venkat

Edited by: Venkat Battula on Aug 18, 2010 7:22 PM