How to unlock the sap* user

[Former Member]

Hi

All my users are got locked.I want to activate the SAP* user to unlock the other users.Mine environment is Linux with maxdb.

how do fix this problem.

Thanks .

[Former Member · Accepted solution]

Hi ,

To activate SAP* you need change parameter value of set login/no_automatic_user_sapstar . Using OS level change the value it to 1. Then login and enjoy .

Regards

ASADUZZAMAN

[Former Member · Accepted solution]

Hi,

after enableing the parameter login as sap* with password pass are try with this query

" Update USR02 set UFLAG=0 where BNAME = '<USER>' and MANDT = '<CLIENT>'

sqlcli -U DEFAULT "select * from usr02 where mandt='000' and bname='SAP*' "

Regards

Zia

[nanda_kumar21 · Accepted solution]

Hi Shilamoni,

The value of login/no_automatic_user_sapstar should be set to 0.

By default it will be 1.

Thnks & regards

Nanda

[Former Member]

Kumar,

Check attached link

[;

You may want to edit instance profile file to add this parameter at OS level if you are not able to get into system. It will be good idea to take backup of that file before modifying.

Hope this helps.

Manoj