if someone lock standard user such as sap* and ddic in
client 800? and client 000 is working fine so how can i log
in client 800?
is there any other standard user with standard password?
Answers were Sorted based on User's Feedback
Answer / kondal reddy
here u have to delete sap* from database level.(usr02
table)
and log in to 800 client with sap* and password pass.
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / kondal reddy
HELLO FRIEND IN DATABASE LEVEL I MEAN
RUN SQLPLUS"/AS SYSDBA"
THEN IN SQL TYPE COMMAND(JUST TRY THIS)
delete sap* FROM SAPR3.USR02 where mandt=client(800)
bname=sap*
JUST TRY FOR THIS.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / kondal reddy
hello friend just b4 i send answer to u in that
sql statement is like this
SQL> delete sapsr3.usr02 where mandt='800'and
bname='SAP*';
THIS ONE IS CORRECT U CAN GO FOR THIS.
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / narendranath gogineni
Kindly requesting u all Don't delete any standard users.
To Unlock the SAP* or DDIC from DB Level following:
from Command prompt: SQLPLUS/nologin
connect SYSDBA
and execute the following command
UPDATE SAPSR3.usr02 SET uflag=0 WHERE bname=USERNAME(sap*)
AND mandt=CLIENT(800)
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sandy
Pls check whether the Env. variables are set for the OS user
you have logged in..
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sanjay
check the profile parameter
login/no_automatic_user_sapstar= o or 1 if this is 1 make
the vaue 0
Restart instance
If this not works then try for
SQLPLUS "/AS SYSDBA"
SQL> delete sapsr3.usr02 where mandt='800'and bname='SAP*';
Is This Answer Correct ? | 2 Yes | 1 No |
how to check if your R3 system is unicode or non-unicode?
ecc full form
what are the activity you have done by using solution manager? please explain briefly some activity
describe how SAP handles Memory Management?
When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?
how to configure JCO Rfc connection and waht is the use of jco rfc?
what are the prerequisite for before applying support packs? Shall I apply sap basis patch to all the system, like BW, ABAP, HR, etc.
What is supplementation language?
Difference between DB Verify and DB Check?
What will happen during the import process?
Where do you download trail version of sap ecc, what is sap cal?
What is redolog file? Path?