Password forgot in 000 client

[Former Member]

Hi Basis Gurus,

We have forgotten our sap* and ddic password in 000 client.

Please tell us the steps how to reset it.

Please help us

Regards,

Anil.

[nelis]

All the above left out one important step before you can login as SAP*, password PASS. You also need to set the following parameter and restart your SAP instance:

login/no_automatic_user_sapstar

Set it to '0'

Regards,

Nelis

[Former Member]

Thnak you all

[Former Member]

Hi Anil,

First change your instance parameter rdisp/login_automatic_user_sapstar to 0 and then go to sqlplus.

sqlplus>>>delete from SCHEMAOWNER.USR02 where mandt='000' and bname ='SAP*';

Then login with user SAP* and new password pass.

Regards

Nick Loy

[Former Member]

Once the SAP* user is deleted, log in with SAP* id and reset the DDIC password. No need to delete the DDIC user id.

Thanks,

Naveed

[Former Member]

Connect to database from os level

c:\documens and settings\sidadm>sqlplus

SQL> delete from Schemaowner.USR02 where bname ='SAP*' and mandt=000;

SQL> delete from Schemaowner.USR02 where bname ='DDIC' and mandt=000;

SQL>commit;

Now login to 000 client with SAP* and password is PASS and create DDIC and SAP* users with new password .

regards,

Pavan

[former_member603052]

Hi Anil,

Connect to DB

SQL> conn / as sysdba

SQL> delete from Schemaowner.USR02 where bname ='SAP*' and mandt=000;

SQL> delete from Schemaowner.USR02 where bname ='DDIC' and mandt=000;

SQL>commit;

Now login to 000 client with SAP* and PASS as password and create DDIC and SAP* users with new password .

Regards,

Kalyan

[Former Member]

Hi Anil,

delete USR02 where BNAME = 'SAP*' and MANDT='000'

Make sure you delete it only in the desired client.

After this, you will be able to log on as SAP* again with password PASS.

Then, you can change the DDIC password and go from there.

Rohit

[Former Member]

and Anil you will have to issue this command at database level through SQL Plus

Rohit