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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top