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.

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.

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.

Answer / zaheer

hi kondal,
but in client 000 is not allowed for any changes in
standard table usr02.

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)

Answer / zaheer

i try in sqlplus directly .when i enter
user as :sysdba
but password i don't know .
is there any standard password for sysdba?
pls reply

Answer / niazi

svrmgrl is the password

Answer / sandy

Pls check whether the Env. variables are set for the OS user
you have logged in..

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*';

Answer / zaheer

thanks,

niazi

How do you change five dialog work processes into batch. Where can you do this?

2 Answers  

Name some drawbacks of SAP?

2 Answers  

What is business kpis ?

0 Answers  

How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?

0 Answers  

you want to do a system-copy. List the steps you will take.

0 Answers  

What do you understand by transport management in sap basis?

0 Answers  

What are the different options available for scheduling a background job? What start conditions type can be used?

0 Answers  

What are the regular activities u do in solution manager and how

0 Answers  

a backroungd job is running...it should have finished in 30min but it is runing for long one day...if you check the process in sm50 it is running and if you check the pid in task manager it is running....it is not hanged and job log does not have error...what will you do to troubleshoot it and how will you convince the particular job owner for killing and rescheduling ?

2 Answers   HCL,

How to increase tables space, resizing, backups and in what situation are these done?

1 Answers  

Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com

0 Answers  

How to apply job on OS Level?

0 Answers