Table or veiw not found

[Former Member]

Hello,

my SAP* used ID got locked in 000 and I am not able to login through other user IDs as system is giving me License check error. Now when I tried to delete sap* user with the command "delete from usr02 where bname = 'SAP*' and mandt = '000';" the system is returning with an message mentioning that the table or view with this name does not exists

Any suggestions?

[Former Member · Accepted solution]

Dear Subhash Chandra and Anindya Bose,

Thanks for your inputs but even after deleting sap* from sql and then re-starting SAP, I am not able to login through SAP*. I tried passwords like pass, PASS, 06071992 and our original password but still the problem persists

Please advice

Rgds

[former_member185031 · Accepted solution]

To login with SAP* this parameter needs to be set by 0

login/no_automatic_user_sapstar = 0

Regards,

Subhash

[Former Member]

The problem was with the SAP* login parameter. Thanks all

[Former Member]

I need to login in 000 client

Still that parameter should be used?

[former_member185031]

Yes becuase you have deleted the SAP* from client 000 and until you wont change the parameter the SAP* users wont be activated.

Regards,

Subhash

[Former Member]

Hi,

By adding this parameter in Instance Profile, you are activating HARD CODED sap* user from Kernel.

login/no_automatic_user_sapstar = 0

Then you need to restart the SAP to use hard coded SAP* user with PASS as a password..

Regards.

Rajesh Narkhede

[anindya_bose]

Use

delete from <SAPCHEMANAME>.usr02 where bname = 'SAP*' and mandt = '000';

you can check SAP SCHEMA name from your SYSTEM--->STATUS

or by running SQL command "Select username from dba_users; " it can be SAPSR3, SAPSID, SAPDAT etc. Just find out that one.

Regards

Anindya

Edited by: Anindya Bose on Feb 23, 2010 2:14 PM

[former_member185031]

Sqlplus / as sysdba

Connect SAPSR3

then execute this delete from usr02 where bname = 'SAP*' and mandt = '000'

Regards,

Subhash