on 03-23-2007 8:25 AM
My all users are locked (DDIC,SAP*) in 000 Client.
I must configure solution manager using 000 client but all users are locked.
How can I unlock them?
Thank you.
I used that SqlPlus command line but gives me error message
(SAPSID = BXD)
sql> update sapBXD.USR02 set uflag=0 where bname='ddic' and mandt=000;
error: table or view does not exist
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Have u run sqlplus sysdba?
sqlplus /nolog
conn /as sysdba.
Then check the following
select owner from dba_tables;
Does this shows a name sapbxd?
If yes
select * from sapbxd.usr02;
Let me know what it shows.
If in the earlier case u havnt connected as sysdba then conn as sysdba and execute the update sql command ie
update sapbxd.usr02 set uflag=0 where mandt=000;
commit;
Hope this will help.
Pl dont forget the points if resolved.
Regards
Hi pl dont mind bbut at least search the forum before posting a new thread.
It has become like spoon feeding.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We encountered the same problem when installing solution manager. The answer is so simple: when you install solution manager (as opposed to an SAP instance) the password of SAP* and DDIC gets set to the password you use during your installation steps. So if you used "abc123" during the install, all the passwords in clients 000 and 001 of these users gets set to abc123.
arey jaffaaaa...@pattnaik
delete sap* from table usr02 - remove the parameter if you have the no logon automatic sap* in the profile - logon as SAP* with the default word of PASS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Solution is
unlocking user DDIC,SAP*:
================
>sqlplus /nolog
>connect / as sysdba
1- Find the owner
sql> select owner from dba_tables;
I find SYS,SYSTEM,SAPSXI, I tested and found that owner is SAPSXI
2- Unlock the users
sql> update SAPSXI.usr02 set uflag=0 where bname='DDIC' and mandt='000';
sql> update SAPSXI.usr02 set uflag=0 where bname='SAP*' and mandt='000';
3-do commit
sql> commit;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can visit this thread
You can search abotu unlocking users in http://help.sap.com too
http://help.sap.com/saphelp_nw04/helpdata/en/70/9be23d44d48e5be10000000a114084/frameset.htm
They may help you out
Regards
Radhika Kuthiala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.