how to delete sap* user in sqldatabase

[Former Member]

hi,

i know how to delete sap* user in oracle database

but i donot know how to delete sap* ser in sqldatabase 2005

my system sid is TE7

can anybody help me

[former_member433984 · Accepted solution]

2 posts earlier you will find this thread:

[Former Member]

Dear fiend

You have to cheke following option

You can delete SAP* from the database with :

DELETE FROM USR02 WHERE BNAME='SAP*' AND MANDT='000';

But this may not clear the lock if the user ID is locked. Also check to make sure that the profile parameter "login/no_automatic_user_sapstar" is set to 0.

shailesh