Answer / hiten modi

Please logon to database, expand table flied, search for
USR02 Table than delete SAP* User ID from 800 client & try
to login in SAP with default SAP* password (pass), and
reset DDIC password from Su01.

Answer / renjith remanan

Hi,

You wrote that your SAP* account is locked only by SAP
Admin.
So I assume that you know the Password....
So its enough to unlock the SAP* from SQL as :
sql> update <db Schema>.USR02 set UFLAG=0 where
BNAME='SAP*' and MANDT='800';

If you dont know the password also, u have to delete the
User SAP* from table. Then it will be again created
automatically with password, "pass".

sql> delete <db schema>.usr02 where MANDT="800" and
BNAMe="SAP*";

Renjith Remanan
Colabera/IBM

Answer / helper

If you are able to login to any other client in the system
(in this case 000), you can run the SQL command from here in
DBA cockpit (ST04, DB13N - from ECC 6.0).
Please get the SQL command to unlock a userID (from table
usr02) based on your Database

Answer / kiran

Login into 000 client with SAP*.

Using RZ11 display the parameter login/no_automatic_user_sapstar.See the Default value will be 1.
Using RZ10 change this parameter to 0.After changing this parameter you need to restart the server.

After that you can login into 800 client using SAP* with password PASS.

Answer / s.m.feroz ahmed

Hi,
One can Login into 800 client through SAPUSER and the
default password is PASS and it is case sensitive.

How should I set priority for Printing say like user, teamlead, project manager?

0 Answers   IBM,

Where the patches are installed (CI or DI or both)?

2 Answers  

How do you configure transport profile?

2 Answers  

what is the procedure for java stack upgradation?

0 Answers   iGate, Yash Technologies,

how sap synchronizes the buffers between the instances of a logon group?

3 Answers   TCS,

what is MCOD ?

2 Answers  

How do I know what threshold values to set

0 Answers  

How you will check whether database is active or not from OS level?

1 Answers  

how do you configure transport profile ?

1 Answers  

I need to change the Company address parameters of a user. The path is SU01 -> <Username> -> Change - > Address Tab - > Display Icon in Company Address section. In the new screen, i see a preview section icon; on clicking which, I can change the parameters such as "Sending Country"; "Street/PO Box number" and number of lines in the resulting pop up. Here though i change the parameter "Street/PO Box number" field to 'S' ( Street has priority over PO Box), its changing again to 'P' (PO Box has priority over street) only. In the help section it is written that if we set the user parameter (tcode SU3) LND1 to the desired country we can control the user specific Sending Country with the desired value else it takes the Sending Country of the Company defined by default. But no such parameter has been given for Street/PO Box number so that we could change its value atleast there. Someone suggest me how to change the Street/PO Box number of the Address format for a user to the desired value.

0 Answers   Wipro,

what is the benefit of tms

2 Answers  

how can we create a particular tables buffer which are mostly used/ And where we can see them ?

1 Answers