how to delete the SAP* from DB level

[Former Member]

hi all

please help me to delete the sap* user from db level access. i mean what is the SQL commands do i need to issue(e.g.... i tried this SQL> delete sap* from user whre bname='sap*' and mandt=000;....please help me thanks in advance

[Former Member · Accepted solution]

hai,

delete from <DBSCHEMA OWNER>.USR02 where bname='SAP*' and mandt=000;

DBschema owner: SAP<SID> if SAP Version is 4.7

: SAPSR3 if SAP Version is Netwever04s onwards and for kernel 700

(for new products try with SAPSR3 or SAPSR3DB)

Ensure that the parameter

"login/no_automatic_user_sapstar" in DEFAULT PROFILE is set to "0" and not to "1" else the user will not be recreated automatically.

Hope this should help u resolve the problem, Plz revert back for further clarifications.

If this solution helps.. plz do fill in the feedback form.

[Former Member]

Hi,

Try qwith following query.

Delete from <SCHEMA>.USR02 where BNAME = 'sap*' and MANDT = 000.

Schema will be either SAP<SID>, SAPR3 or SAPSR3 depending upon your SAP version.

Regards,

Payal