on 10-18-2007 11:33 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.