sap* user id unlock

Sunday, May 20, 201226comments

How to unlock SAP* user id.

As a Basis Consultant many times we require to unlock or rename SAP* user id in system.
Providing few oracle sql command to rename or unlock the SAP* user id

Rename SAP* user id

update sapsr3.usr02 set bname='SAP*1' where bname='SAP*' and mandt='500';

and then try to login into client from SAP* user id. Default password is pass

Unlock sap* user id.

update sapsr3.usr02 set flag=0 where bname="ddic" and mandt='500';

or

update sapsd1.usr02 set uflag=0 where bname='SAP*' and mandt='220';

To check the status of SAP* user id
select status from sapr3e.usr02 where bname='SAP*' and mandt='220'

Delete SAP* user id.

delete from sapsr3.usr02 where bname='SAP*' and mandt='020';
Share this article :

+ comments + 26 comments

September 21, 2012 at 10:57 PM

where we have to execute these commands.

screenshots would be help ful

January 31, 2014 at 8:54 PM

nice post thank you

February 2, 2014 at 11:34 PM

very useful information swathi

February 16, 2014 at 6:52 PM

thanks for sharing this information nice

March 14, 2014 at 2:49 AM

Very useful information for us thank you Latha Pallavi

October 6, 2014 at 3:49 AM

For your information:

http://cursosapnetweaver.com/sap-basis/resetear-desbloquear-usuario-sap/

Best regards.

October 27, 2014 at 6:34 AM

Thanks for InformationSAP Online Training

June 27, 2015 at 5:04 AM

Thanks for posting This...
Real time training in SAP FICO

July 10, 2015 at 10:43 PM

This site is very good to me. Because this site has much more sense post. So I am posting at the site. I would like to know more of the unknown. Top posts and takes a lot of good to me and to all of the beautiful and the good. SAP IDES Access

January 18, 2016 at 9:00 PM

Thanks for sharing this article! Has cleared many of the doubts.
For information on SAP Basis visit http://www.runsapbasis.com/

February 10, 2016 at 9:46 PM

i just came across a good website for training related information. May be it is useful to for any one looking for SAP training institutes in India. Sap fico interview questions and answers | Automatic credit control in sap sd

March 6, 2016 at 11:29 PM

Thanks for the great information in your blog SAP SF Training in Chennai

March 14, 2016 at 11:08 PM

Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about SAP BASIS

May 4, 2016 at 11:28 PM

Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai

July 4, 2016 at 6:36 AM

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on SAP

August 22, 2016 at 11:46 PM

Great place to learn new things and got the best SAP BASIS Training in Chennai

September 23, 2016 at 5:12 AM

Hi all,
i have installed SAP 4.6c in my desktop. i have only 1 userid & 1 password.i have forgotten my password.
so i tried so many times then finally user is locked. so how to unlock this user or how to login to sap?
i do not have any other user id .This user id is locked for all the clients. plz give some suggestion.




SAP training in Chennai


SAP FICO training in Chennai

October 21, 2016 at 11:31 PM

Nice post cool information ON SAP BASIS Domain.
SAP Training | SAP Training in Chennai | SAP Training Institute in Chennai

November 5, 2016 at 3:37 AM

it is very nice article thanks for sharing this article to us , it is very nice article ,
i really like like this article because i got good info about this article thanks for sharing this article to us best regards.

sap netweaver training in hyderabad

December 24, 2016 at 2:18 AM

It was very nice blog to learn about SAP BASIS. Thanks for sharing
We provides Best SAP BASIS. Training in Chennai with real time project assistance by our leading SAP BASIS. Consultant.
For Free Live Demo @ Call to 8122241286.
SAP MM, SAP SD, SAP HR,SAP FICO 
www.thecreatingexperts.com 
.SAP basis

January 17, 2017 at 9:38 PM

Creating experts, A leading career development organization provides Real time training in SAP Success Factors, SAP MM, SAP SD, SAP ABAP, SAP BASIS,SAP BASIS, SAP FICO, with live examples by corporate Experts.
www.thecreatingexperts.com (Best SAP training institute in chennai with placement assistance)
SAP Success Factor, SAP MM Training in chennai Vadapalani ECR velachery Tambaram
SAP basis training in chennaai

January 20, 2017 at 9:46 PM

Ad 7 SAP BASIS
It was very nice blog to learn about SAP BASIS. Thanks for sharing
We provides Best SAP BASIS. Training in Chennai with real time project assistance by our leading SAP BASIS. Consultant.
For Free Live Demo @ Call to 8122241286.
SAP MM, SAP SD, SAP HR,SAP FICO 
www.thecreatingexperts.com 
.SAP basis

May 10, 2017 at 12:13 AM

Brilliant blog post. The information here is absolutely wonderful. I could not have asked for a much better post than this one you've submitted today. Keep giving more posts like this. sap cloud erp

June 16, 2017 at 11:21 PM

Thank you for your post..much helpful to know things better.

I personally got trained with THE CREATING EXPERTS one of the best trainer in CHENNAI with hands on training in real time scenarios.

It would be useful for the viewers to take a look at the provided link below for SAP trainings.

http://thecreatingexperts.com/sap-basis-training-in-chennai/

Post a Comment
 
Support : Basis SAP | Basis SAP | Basis SAP
Copyright © 2011. Basis SAP - All Rights Reserved
Template Created by Basis SAP Published by Basis SAP
Proudly powered by Blogger