Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on SAP Basis

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close