Deleting SAP*

[Former Member]

I need to logon to one of our Systems and none of the Passwords are working.. I need to delete SAP* at the OS level.. so that i can get into the system..

SAP is 4.6C and oracle is 9i..I Need to know the SQL statement through which i can do that..

Regards,

Ershad Ahmed .

[Former Member · Accepted solution]

hi,

at OS level go to sql script and type

SELECT '' FROM USR02 WHERE BNAME = SAP, MANDT = CLIENTNO.

there you can delete the password of sap*. after that you can get the default password as PASS.

with regards,

Harish Reddy

[Former Member · Accepted solution]

Hi,

if it still does not work, set the profile parameter "login/no_automatic_user_sapstar=0" in your instance profile and restart the SAP instance. (See OSS note 806819).

Best regards,

Elmar.

[Former Member]

I got the Answer.

SQL>delete from SAPSCHEMA.usr02 where mandt=`000' and bname='sap*';

Regards,

Ershad Ahmed.

[Former Member]

OS is AIX