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

Name of the ABAP program to delete background jobs?

7 Answers   Cap Gemini,

how do u relese chage request? is it possible to relese change request without relesing task?explain step by step

1 Answers  

How will you do a local client copy? Just tell us up to the point where you monitor the progress. What if SAP* user is not available at all in your system then how u will do client copy?

2 Answers  

What are the different modules of SAP?

0 Answers   EX,

Explain segment?

0 Answers  

I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.

0 Answers   Satyam,

Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?

0 Answers  

What is the difference Between Role and Profile

20 Answers   Accenture, HCL, REL, TCS,

if any errors comming during transport where it will be recodred and how will you rectify? transport log and active log?

2 Answers   iFlex,

HI Good Evening This is chenna my qualification is mca. now am learning sap basis... so i don't know idea about sap basis can u give some suggestions on sap basis... and any interrview questions and answers (fresher and exp)links send my id: apps.chenna@gmail.com..

1 Answers  

what is the difference with oracle 9i and 10g?

2 Answers   CTS, IBM,

What is Extractor?

2 Answers   SAP Labs,