How to delete the line for 300SAP* in table USR02 in SQL Management studio

[Former Member]

Hello

I used to delete the line for 300SAP* in table USR02 in SQL Enterprise Manager. After I could log on with “pass”.

I wander how to delete it in SQL Management studio. When I expand tdatabase it takes so long time and it is uncontrollable

[kishore_soma]

Hi Tina,

This is really simple.

Go to Enterprise manager, browse the table and as you delete a row in the excel the same way delete the row you desired to delete. or use the script to delete

<u><i><b>But always modify anythign through the SQL script only</b></i></u>

[clas_hortien]

Hello,

you have to delete the row by a sql statement.

Open a new query and run a script like this:

use <Your SID DB> -- e.g. use PRD

setuser 'your sid in lowercase' --- e.g. setuser 'prd'

delete from USR02 where MANDT = '300' and BNAME = 'sap*'

go

Run a complete backup before deleting data manually.

Regards

Clas