Skip to Content
avatar image
Former Member

Unlock User and Reset Password via DB

Hi,

I've a SAP FI running on Oracle. I have the SAP ID but no password.

I've the access to the Oracle DB. How do I unlock the ID and reset the password via the DB.

Please advise.

TIA !

Desmond

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 10, 2009 at 06:36 AM

    Hi,

    If you have OS level access, go to Start -> Run -> Connect /sysdba/ (when you login like this, there is not authorisation reuired for Oracle)

    Then you can unlock the user via running the normal SQL command.

    Or else, login to BR TOOLS and from there you can change the password.

    Hope it helps.

    Thanks and Regards, Pradeep

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Actually, it did not really work in any release, but created a bigger mess in earlier releases and in higher releases the downward compatibility settings of the password hashes can be used to completely exclude updating the hash only to have any affect (except a lock-out....).

      Of course, to get back into a system lockout caused by such "cowboy" actions... there is an emergency procedure. See [SAP Note 2383|https://service.sap.com/sap/support/notes/2383].

      Cheers,

      Julius

  • avatar image
    Former Member
    Feb 12, 2009 at 06:27 AM

    Hi Desmond,

    You can unlock SAP user id from DB level, but there is no way you can reset password for SAP user id from DB level.

    Below is the command for unlocking user id from DB level.

    Connect to orasid.

    sqlplus "/as sysdba"

    SQL>update sapr3.user02 set uflag=0 where bname='userid' and mandt='<clientno>'; -- for older SAP versions

    From ECC 5

    SQL>update sap<SID>.user02 set uflag=0 where bname='userid' and mandt='<clientno>';

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded