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

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