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';
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
Thanks for the help!