SAP* and DDIC Users

[BalaMalvatu]

<b>Dear Forum ,

I have successfully Installed the SAP WAS NW04S .

After that I Installed GUI.

When I am trying to log in , the DDIC and SAP* Users Were Locked.

Can anybody Help in logging into SAP or change the password of those users directly from my SQL database using a query.

Regards

Bala</b>

[BalaMalvatu]

I tried on my Own in DataBase Directly and changed the status to 0.

Thank you forum in considering my Request.

Hope We may meet again.

Bala

[Former Member]

Hi,

You can delete SAP* user from table USR02 and then relogin using SAP* and pass as the password.

This can be done for any client.

For this go to transaction se16 and enter USR02 and after that press on the first icon which says table contents and on the next screen you get press on execute(or press F8). You can see the list of user in this table just select sap* and delete.

reward with points...10 if it solves your problem else suitable points are expected.

[Former Member]

Hi,

Do it from sql prompt. Proceed as under:

If you havent changed the default password for DDIC and if DDIC isnt locked try the following password 19920706. Reverse of SAP* password.

If ddic is locked then u can unlock it from SQL command.

In the cmd prompt proceed as under:

SQLPLUS /NOLOG

CONN /AS SYSDBA.

SELECT BNAME, UFLAG FROM SAP<INSTANCE ID>.USR02 WHERE UNAME = 'DDIC'

If uflag is not 0 then ddic is locked.

Proceed as under to unlock it.

UPDATE SAP<INSTANCE ID>.USR02 SET UFLAG = 0 WHERE UNAME = 'DDIC' AND MANDT = '800';

COMMIT;

This will unlok the ddic user and login with the default password.

or Delete the sap* user as under

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

after doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).

Hope this will help.

Pl dont forget to award points if resolved.

Regards

[Former Member]

Hi, Bala

Please refer to this thread.

Good Luck.

Sejoon