Question Re: SAP* user unlock in Additional Q&A

SAP* user unlock

Former Member — Sat, 26 Jul 2014 20:35:57 GMT

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.

Re: SAP* user unlock

Reagan — Sat, 26 Jul 2014 23:42:34 GMT

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

Re: SAP* user unlock

Former Member — Sun, 27 Jul 2014 06:20:20 GMT

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.

Re: SAP* user unlock

Former Member — Sun, 27 Jul 2014 15:16:28 GMT

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

Re: SAP* user unlock

Former Member — Thu, 31 Jul 2014 17:17:15 GMT

Hi Subba,

Using the Tcode RZ10 create a profile parameter in instance profile

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

Re: SAP* user unlock

Former Member — Fri, 01 Aug 2014 10:08:14 GMT

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

Re: SAP* user unlock

Isaias_SAP — Thu, 11 Sep 2014 16:05:22 GMT

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