SAP* user unlock

[Former Member]

Hello

I just want to enable the user SAP* after system refresh.

but strange thing in my system, i am not able to see the SAP* user in system. Below is the script i tried.

SQL> select bname,uflag,mandt from SAPXER.usr02 where bname='SAP*';

no rows selected

I tried to delete the user from 000, but no luck.

SQL> DELETE  FROM SAPXER.USR02 WHERE BNAME='SAP*' AND MANDT='000';

0 rows deleted.

I tried with this cmd to update the SAP* user,

SQL> update SAPXER.USR02 set BNAME='SAPstar' where BNAME='' and MANDT='000';

0 rows updated.

Update cmd also doesnt work for me. When i try to find out the user in system. user SAP* doesn't exits as i mention in 1st script.

Any idea how to create the user(SAP*) in all client. When ever we delete the user it is not automatically created after bouncing the system.

Please help us.. Thanks in advance.

[Former Member · Accepted solution]

Hi Subba,

Using the Tcode RZ10 create a profile parameter in instance profile

login/no_automatic_user_sapstar  and set it to 0.

Take a system restart so that the parameter gets active.

now try to delete the user

at cmd type these commands

>sqlplus / as sysdba

SQL>conn SAPXER/<your password>

SQL> delete from usr02 where mandt=000 and bname='SAP*'; //you can see the user deleted

SQL> commit;

now login to 000 using  SAP* and password pass.

The query you mentioned at the start select bname,uflag,mandt from SAPXER.usr02 where bname='SAP*';

will not work as it has no MANDT in that

Hope this helps..

Thanks,

Pavan