How to unlock the user

[Former Member]

Hi guru's

When iam logging in the s/m after giving the user name and password it saying that user is locked, how to unlock ? and to log in the sap s/m mine is ides version of 4.6c.

regards,

NARASIMHA

[Former Member]

Hi Lakshmi,

I hope you already had a suitable solution for your prob and must hv resolved it.

Pl award suitable points and close the thread.

Regards

[Former Member]

hi,

give this profile parameter login/failed_user_auto_unlock = 1

in your instance profile manually.this profile in

Install Drive:\usr\sap\<SID>\SYS\profile\<SID>_DVEBMGS<instance no>_<host name>

regards

ajai

[Former Member]

Hi ,

One more point to add in addition to what Subash has suggested.

I fyou know the user id and password instead of going thru sap* abd unlocking the user , you can directlly unlock the user from sqlplus by the following sql:

sqlplus /nolog

conn / as sysdba;

update sap<sid>.usr02

set bflag = '0' (ZERO)

where bname = 'username';

commit;

If the bflag for a paricular user in table usr02 is

0 Not Locked

32 Locked Globally By Administrator

64 Locked Locally By Administrator

128 Locked Due To Incorrect Logons.

Pl award suitably.

Regards

[Former Member]

Login with Sap* or DDIC user if you know the password of those users or you can unlock the user from Sql promt

execute this

Sqlplus /nolog

connect as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

enter the client number and user name

in this option the user SAP* will be reset and then you can login with the default password of sap* is password.

Regards

Subhash