sap* user id unlock

Sunday, May 20, 201241comments

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 + 41 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/

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

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

July 11, 2017 at 11:49 PM

SAP BASIS Training in Chennai is provided by

THE CREATING EXPERTS they provide hands on training with real time scenarios

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

contact 8122241286 for more info

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

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.

July 22, 2017 at 1:40 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

July 22, 2017 at 5:47 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

July 24, 2017 at 2:26 AM

SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

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

contact 8122241286

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.

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

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.

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

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