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 |
What is Hour Glass state? and how does it be resolved
What is SAPS?
How to find SAP up or not in Unix? What is the command?
what are the current support stack levels at market place?
How u will assign Logon Groups?where u find logo.ini
Table space creation
While applying support packages, the error Table space overflow is occured? What could be done?
How to find expensive SQL statement, if found, what should be done?
How to see the t able entry values?
How can you view locked transactions?
What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?
What is JVM switch. Why JVM switch is required ?