User sap* login issue

[Former Member]

Dear Experts,

i changed the password for the user sap*, its working fine in 000 client. But i have another client's like 400 and 500. i try to log-in in 400 client its not log-in. but in 500 client its log-in by default password "pass". how to solve this issue, kindly explain and give solution ASAP..

Warm Regards

Chandru

[former_member183107 · Accepted solution]

If it is a ABAP or dual stack, activate SAP* by checking/changing the parameter login/no_automatic_user_sapstar to 0 at the OS level and restart SAP. You should then be able to login with SAP* and password PASS. If this does not work, you probably have the usermaster for SAP* in which case you can delete the user at the database level.

If the user SAP* is already locked, you have to set the field "UFLAG" in table <SCHEMANAME>.USR02 to "0" for SAP* at the database level.

Hope this helps.

Himanshu

[Former Member · Accepted solution]

Dear Sharma,

after i restarted the sap its working fine...

regards

Chandra Sekar V

[former_member183107 · Accepted solution]

Good to know the issue solved.

Regards,

Himanshu

[ashish_vikas]

If parameter login/no_automatic_user_sapstar = 1 then you wont be able to login with SAP* and pass. this parameter should be 0 to login with SAP* and pass

after this, delete the user SAP* in 400

SQL> Delete from SAPSR3.USR02 where MANDT='400' and BNAME='SAP*';

1 row deleted.

SQL> commit;

Commit complete.

after this SAP*/pass will work in 400 client.

best regards

ashish

[former_member183107]

This message was moderated.

[Former Member]

Hi,

run the following sqls:

delete from sap<SID>.usr02 where bname='sap*' and mandt='XXX';

commit;

log on to the system with password: PASS

if still doesn't work, set the profile parameter "login/no_automatic_user_sapstar=0" in your instance profile and restart the SAP instance. (See OSS note 806819).

If you DB is oracle.

Thanks

RishiA brol

[Former Member]

Dear Rishi Abrol,

i changed the profile to 1 before that i set the private password to log-in, its only working in 000 client but in 500 client default pass only taking.

secondly

why it is not login in 400 client. what would be the reason,

Regards

Chandru...

[ashish_vikas]

secondly
why it is not login in 400 client. what would be the reason,

If the user master for SAP* have been created, it will not work. So you need to delete this from USR02 table as suggested.

[Former Member]

Dear Vikas,

how can i delete that, we are using hp-ux 11i v3 with oracle back-end.

regards,

Chandru

[ashish_vikas]

you need to use SQLPLUS for oracle.

SQL command have been already suggested.

best regards

ashish

[Former Member]

Hi,

Did you run the SQL query three time one for mandt =000 ,one for mandt =400 and one for mandt =500.

If yes then it should work. But if not it will not work.

Thanks

Rishi Abrol