Unlock User and Reset Password via DB

[Former Member]

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

[pradeepmathewch]

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

[Former Member]

Hi,

May I know what are the SQL commands to run ?

I'm not referring to the Oracle DB ID, but the SAP ID which is stored in USR02.

Thanks !

[Former Member]

There was a dirty trick to do this in older releases because the password hash did not have a system specific attribute to it, but this no longer works in higher releases.

It was never supported to do this anyway, and you will with certainty create an inconsistency and a resultant mess.

The correct procedue is to ask an application user administrator to reset your password for you to an initial one, and then login yourself and change it to one of your own.

Cheers,

Julius

[Former Member]

Hi,

Thanks for the info. What's the oldest release whereby this trick doesn't work ?

My SAP is ver 6.

TIA !

[Former Member]

Hi,

What if no one knows any password at all ??? Even the administrator !

[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

[Former Member]

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.