CLIENT CREATION

[Former Member]

HELLO TO ALL EXPERTS,

I AM HAVING THIS PROBLEM THAT WHENEVER I AM CREATING A NEW CLIENT AND TRY TO LOG INTO IT USING SAP* OR DDIC AND PASSWORD AS PASS IT'S GIVING ME AN ERROR SAYING USER OR PASSWORD IS INCORRECT. PLEASE HELP

THANKS IN ADVANCE

[Former Member]

Hi,

Your sap* user ID may be locked

1.

If you have access to su01 through some other user id then unlock the sap*

2.

At database level you can change the table USR02

sqlplus '/as sysdba'

update USR02 set UFLAG='0' where BNAME='SAP*' and MANDT='<client number>';

Commit

3.

Set parameter

login/no_automatic_user_sapstar to 0

stop and start SAP

Now try to login using sap* and password "pass"

Rakesh

[Former Member]

when i type the given sql query that u have provided it gives an error saying that table or view does not exist

regards

moid

[Former Member]

You need to login as Sysdba and then execute the query

SQL> delete from <SchemaOwner>.usr02 where bname=u2019SAP*u2019 and mandt=u2019000u2032;

1 row deleted.

SQL> commit;

Commit complete.

You can delete the SAP* user using ABAP code(000 Client) :-

Delete from usr02 where bname = 'SAP' and mandt = '**

Guess that helps

Rakesh