on 07-26-2014 9:35 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.