Unable to log in after deleing a user using SU12

[saravanaraj_nadaraja3]

Hi Gurus,

We removed few inactive users using t-code SU12, now we are unable to login. I have tried with SAP* and DDIC as well?

Any idea?

[former_member182034 · Accepted solution]

hi Sarawanraj,

if you have removed all users then you can login with sap* If you remembered the password of sap* then you can login otherwise you need to run following commands.

The command would be

SQL> delete sapsr3.USR02 where bname='SAP*' and mandt='client_number';

SQL> COMMIT;

after that you need to make sure the following parameter with their value in instance profile.

login/no_automatic_user_sapstar = 0

restart the instance and now you can logon with SAP*.

Regards,

majamil