Unable to login into 800 client

[scorpian]

Hi
I installed ecc6 ides on my home desktop. now the problem is that i am unable to login into the default 800 client with sap* user id. earlier when i created a new client and when i am unable to login, i changed the parameter login/no_automatic_user_sapstar by default this value is 1 and I set it to 0 in 000 client . Can anyone help me in this regard.

[ratnakar606]

Hello Scorpian ,

Could u please tell me the error message what it is prompting while entering the user id and password.

With Kind Regards

Ratnakar gurugubelli

[srikant]

IN ides CLIENT 800 WOULD BE HAVING THE DUMMY DATA. WHICH USER YOU ARE TRYING TO LOGIN WITH, WE CAN RESET THE SAP* USER FROM ORACLE DATABASE DIRECTLY

[scorpian]

Hi srikanth!!!
Thnks for the reply. can u tell me the procedure for resetting the sap* user from oracle database directly.

[zamu84]

Hello Scorpian

to reset the password

u have to login as a dba admin into the database and from there u can execute
this command

>delete from sapr3.usr02 where bname='SAP*' and mandt='000'

correct me if i am wrong

Regards
Zamu

[hussaini]

hi zamu

u gave the command

>delete from sapr3.usr02 where bname='SAP*' and mandt='000'

in which the database schema is wrong it should b sapsr3

delete from sapsr3.usr02 where bname='SAP*' and mandt='000'

[scorpian]

hi hussain!!!
i tried with the command tht u mention here. but itz showing the message tht particular table or view doesnt exist. is there any other way to reset the password. if possible plz send at sap level rather than at os level


regards,
scorpian

[chakrishroff]

Hi Scorpian,
Table USR02 must exist in the database. May be the schema you are using is wrong. by default the system creates schema by the name SAPSR3. if you have not changed this schema name at the time of installation then what you have used is correct. try using the same command in upper case.
also SAP* should be in upper case.

[saleemzm]

hello friends i am your junear right kow i am learning BASIS .AND ALL THE BEST ALLOFF U U WILL BE IN GOOD POSITION THANKU