Sap* and DDIC user login issue
I forgot the SAP* and DDIC password in 001 client. I donot have any other user to login into 001 client.
But I can login into 000 client.
How to reset the password in 001 client ?.
You got to deletre SAP* from the database
Proceed as follows:
1.Check your instant profile and make login/no_automatic_user_sapstar is set to "0" and now make a restart of your server.
Try this from command prompt.
conn /as sysdba;
Now type this and take caution as this is case sensitive:
DELETE FROM <sid>.USR02
WHERE BNAME='SAP*' AND MANDT='<client no.>'
DELETE FROM dev.USR02
WHERE BNAME='SAP*' AND MANDT='001'
Then restart your server and login as user SAP* password pass.
Hopefully this will work.