Ask the Expert

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.

    Requires Free Membership to View

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.

update USR02 set UFLAG=0

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

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: