login to client 001

Question: Earlywatch has flagged that ID SAPCPIC standard password is not changed in client 001. Cant login in as sapcpic because it is not a dialog user id. I don't know what sap* and ddic are set to in client 001. And login/no_automatic_user_sapstar is set so i can't delete sap* and login that way.

is my only option to remove login/no_automatic_user_sapstar, login sap sap* and change then set login/no_automatic_user_sapstar back?



Reply i received;

If you do not use SAPCPIC at all in client 001, I would try to go to the the sql query tool or sqlplus and do:

select bcode from sapr3.ocod1 where mandt='001' and bname='SAPCPIC';

You will get a string, I believe.

Change a character or two in the string, and do an update on the table as follows:

update sapr3.usr02 set bcode = 'changed_string' where mandt=001 and bname='SAPCPIC';

That would avoid the whole problem of having to enable sap* and disable sap* again.

Please let us know,

Answer:
i get table or view does not exist from;

select bcode from sapr3.ocod1 where mandt='001' and
bname='SAPCPIC';

Answer:
i get table or view does not exist from;

select bcode from sapr3.ocod1 where mandt='001' and
bname='SAPCPIC';

command should be:

select bcode,ocod1 from sapr3.usr02 where mandt='001' and
bname='SAPCPIC';
_________________