how we can logon on 800 client if user sap* and ddic is
lock by sap admin. but client 000 is login successful.
is there any other way? from 000 client.
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 22 Yes | 4 No |
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
Is This Answer Correct ? | 9 Yes | 1 No |
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
Is This Answer Correct ? | 2 Yes | 1 No |
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.
Is This Answer Correct ? | 4 Yes | 4 No |
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.
Is This Answer Correct ? | 3 Yes | 13 No |
Why is java Required while installing SAP
Explain central instance?
What the immediate steps if the instance did not came up after restart in both AS ABAP and AS Java?
Explain what is business kpis ?
Apart from Update WP,which WP can also perform update in Database?? When we give print request, which WP comes into the picture??
How to add datafile using brtools?what are steps?
how to configure jco connection from ep to backend(ECC or bw or crm) systems?
How to lock a transaction?
how can u change the location of control files of oracle in sap?
What is Consolidation route and delivery routes? How to define Logon groups? And what is Logon load balancing? What is Transport domain and Domain controller?
could u explain the transport steps (step by step) procedure?
11 Answers IBM, TCS,
HOW CAN I DO HOMOGENOUS SYSTEM COPY (ECC5.0)?TELL STEP BY STEP PROCESS?