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 can i decleare select-options in module pool table control?

0 Answers  

What is the procedure to apply Patches?

5 Answers  

What will you observe in System log (SM21)?

1 Answers  

how to find if there are an expensive sql statements running.if yes,what to do?

2 Answers   iGate,

How to make a copied client from the Client 000 cannot be customized?

2 Answers  

What is the importance/need of Virtual system?

5 Answers   TCS,

What do will do in OS level monitoring

3 Answers   HCL,

How to do client copy?

1 Answers  

if somebody changes printer configuration or say,deletes printer,how do you find who did it?

1 Answers   IBM,

If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log

0 Answers  

Consider a client 800 this client having 75 users but 15 users account was locked, I want to unlock this 15 users account at a time how you do?

6 Answers   IBM,

If you have a long running job how do you analyze?

2 Answers