Q

Resetting SAP passwords

I installed SAP 4.6B in my PC seven months ago, and I have forgotten all user passwords. While I am trying to login to SAP, the system shows an error message as: SAP locked, ask administrator to unlock.

My question is: First of all, how can I unlock SAP, and second, how do I reset all passwords from the Oracle site? I need a standard Oracle userid and password to do these tasks.

You can do this at the database level. Run a SQL update query that changes the field UFLAG to 0 in table USR02 for all users.

Example:
update USR02 set UFLAG=0

Then, delete the SAP user account by running a delete SQL query against USR02.

Example:
delete USR02 where BNAME='SAP*' and MANDT='000'

Then you'll be able to login as SAP with password PASS. This will allow you to reset the password for your other accounts.

This was first published in January 2005

Dig deeper on SAP Basis administration and NetWeaver administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close