cancel
Showing results for 
Search instead for 
Did you mean: 

My all users are locked (DDIC,SAP*) in 000 Client.

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi pl dont mind bbut at least search the forum before posting a new thread.

It has become like spoon feeding.

Regards

Former Member
0 Kudos

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.

Former Member
0 Kudos
Former Member
0 Kudos

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.

Former Member
0 Kudos

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;

Former Member
0 Kudos

Thank you ! That was really helpfull.

I appreciate your message.

Former Member
0 Kudos

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