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

[Isaias_SAP]

Hello Subba,

In order to reset the "SAP*" user, you need to perform the following steps (on that same order):

1) Execute the following SQL command at the database (notice that you need to adjust the "mandt=..." parameter):

delete from usr02 where mandt='<client>' and bname='SAP*';

2) Set the profile parameter "login/no_automatic_user_sapstar = 0" and restart SAP.

You can then logon as "SAP*" with one of the default passwords (the password will be either "06071992" or "PASS" - all in uppercase letters).

Don't forget to remove the parameter from point #2 and restart SAP again, once you don't need to use the SAP* user anymore.

Cheers,

Isaías

[Former Member]

Hi Subba,

FYI: If you delete the user SAP* it will automatically create the user and the password will be ''pass".(provided you set the profile parameter)

if you don't want to delete the SAP* user and activate the user with the same master password which you provide during installation go with this query.

update usr02 set uflag=0 where bname='SAP*' and mandt=<your_client_number>;

the significance of uflag as follows

UFLAG Value Status

0 User not locked

32 Locked by CUA central administrator

64 Locked by administrator

128 Locked after failed logon

192 Locked by administrator + Locked after failed logon

96 Locked by CUA central administrator + Locked after failed logon

160 Locked by CUA central administrator + Locked after failed logon

Thanks,
Pavan

[Reagan]

First read this thread to understand how the SAP* works. I have already explained it before.

http://scn.sap.com/thread/3392213

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

no rows selected

Are you sure that the schema is SAPXER ?

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.

No surprise. When there is no SAP* user in the database then how will a delete statement work ?

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.

Is the where clause correct ?

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.

If there is no SAP* user present in the SAP system then you need to login to the system (either by activating the emergency SAP* user or using another user) and create the user using the Tx SU01.

Regards

RB

[Former Member]

Hi,

The schema is correct only, as i mentioned system copy was performed to another host. there is no permanent license in  system to allow other user.

when i tried to check SAP* user in DB level user doesn't exits. can you suggest how to enable SAP* to apply license..

Thanks in advance.

[Former Member]

Hi Subba,

Please set login/no_automatic_user_sapstar = 0 in instance profile.

Take SAP restart

Post this you can login with SAP* and password as pass.

It looks like SAP* user does not exists in your system and hence the query returns 0 records.

Hope this helps.

Regards,

Deepak Kori