cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to delete sap* from sql

Former Member
0 Kudos


Hello experts,

My sap* is locked due to incorrect password attempts hence i am trying to delete it using the command->"delete from SYS.USR02 where bname='SAP*' and mandt='000';

i am getting the below error

"no file or directory"

i have installed an ides system on windows, please help.

Accepted Solutions (0)

Answers (3)

Answers (3)

divyanshu_srivastava3
Active Contributor
0 Kudos

1st use the correct schema name, for eg SAPSR3.USR02.

former_member182657
Active Contributor
0 Kudos

You could also refer SCN thread SAP* & ddic password locked in 000 client | SCN

Regards,

former_member182657
Active Contributor
0 Kudos

Hi,

delete from SYS.USR02 where bname='SAP*' and mandt='000';

Should be as like delete from SAPSR3.USR02 where bname='SAP*' and mandt='000';

Regards,