sap* user id unlock

Sunday, May 20, 201239comments

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 + 39 comments

September 21, 2012 at 10:57 PM

where we have to execute these commands.

screenshots would be help ful

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

Anonymous
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

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

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

Anonymous
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/

Anonymous
June 29, 2017 at 6:22 AM

The Creating Experts is the leading trainer in SAP BASIS so, if you are looking for one here is the link

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

contact +91-08122241286

Anonymous
July 2, 2017 at 10:32 PM

SAP BASIS training is provided in CHENNAI.

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

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

contact 8122241286

July 11, 2017 at 3:47 AM

The Creating Experts provides training in SAP basis

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

contact +91-08122241286

Anonymous
July 14, 2017 at 5:46 AM

Nice blog....For a long time I was looking for SAP BASIS training in Chennai and got the link


THE CREATING EXPERTS is providing SAP BASIS training in real time

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

Contact 8122241286

Anonymous
July 15, 2017 at 3:58 AM

SAP BASIS training is provided in CHENNAI.I personally got trained with them one of the best trainers in CHENNAI

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

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

contact 8122241286

July 21, 2017 at 1:15 AM

Informative post...for a long time I was searching for a trainer in Chennai

And i landed with THE CREATING EXPERTS one of the leading trainer with real time training in Chennai

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

contact 8122241286 for more info.

Anonymous
July 27, 2017 at 7:17 AM

SAP basis training by THE CREATING EXPERTS

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

contcat 8122241286 for more info.

If you are looking for SAP basis here is a real time trainer to get trained from.

Anonymous
July 28, 2017 at 8:47 AM

Creating experts, A leading career development organization with live examples by corporate Experts.

SAP training by online and classroom training is provided

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


Contact 8122241286 SAP basis training in chennai

Anonymous
July 30, 2017 at 1:57 AM

The Information you provided is very much useful for SAP Learners. This Information was very Interesting,

SAP training in Chennai by THE CREATING EXPERTS for SAP BASIS, take a look at the link below

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

contact 8122241286 for more info.

Anonymous
July 31, 2017 at 9:39 AM

NICE BLOG...SAP basis training in CHENNAI provided by THE CREATING EXPERTS

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

CONTACT 8122241286.

October 25, 2017 at 12:23 AM

This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.

Eczema Treatment

June 27, 2018 at 11:11 PM

Superb explanation & it's too clear to understand the concept as well, keep sharing admin with some updated information with right examples.Keep update more posts.
Journal Publication
Academic Journals
Art Journal
Academic Publishers
Journal Publishers

September 27, 2018 at 9:51 PM

Very nice post here thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's
Sccm Training

October 17, 2018 at 11:54 PM

Extremely Decent. This blog is very informative.But few points are missing which needs to be explain in a proper way. you go through our website http://www.svtrainings.com to grab that information systematically. SV TRAININGS provides best SAP Hybris Online Training please visit http://www.svtrainings.com. Contact: Mr.Shrinivas :

Call/whats app : +91-9642373173 and +91-9966624055 Mail: info@svtrainings.com

October 29, 2018 at 10:12 AM

For IT Online Training Please visit Visit Us

January 13, 2020 at 4:05 AM

Thank you for sharing nice blog
web designing course in uttam nagar

January 22, 2020 at 3:14 AM

SysAppPro Gurgaon is one of the most credible ERP HR training institutes in Gurgaon offering hands on practical knowledge and full job assistance.
For More Info: SAP HR Course in Gurgaon

February 27, 2020 at 3:33 AM

Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my websitemicroservices online training

February 27, 2020 at 3:34 AM

Thanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my websitemicroservices online training

July 28, 2020 at 7:26 AM

Nice blog ,Thanks for sharing..For more info
SAP Training in chennai

October 26, 2020 at 6:17 AM

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...

Digital Marketing Certification Training
AWS Certification Training
Python Certification Training
Selenium Training
Data Science Certification Training
DevOps Certification Training

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