Skip to Content
0
Former Member
Jul 26, 2014 at 08:35 PM

SAP* user unlock

2090 Views

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.