SQl Dropped

So server was hacked again last night db dropped all ports are closed so must be register script doing the hacking

would it be possible if i set user ie: sa to only be able to create not drop/delete tables
and make another account so i can manually drop or delete or wont this work ?

If you are using user sa on your DB then is obvious that you will get hacked soon or later.

no not using login sa was putting as example but all ports are closed i hear setting odbc connection local away but how do i go about this

Create a new user ONLY for the register page that only have permission to create data.

thnxs

what server was is cause i did that to 3 servers lastnight and made myself GM name is IceT. I did the exploit sending SQL query thru SMC login using '; INSERT INTO TB_User (StrUserID, password, sec_primary, sec_content) VALUES ('test','4297f44b13955235245b2497399d7a93','1','1' ); -- if that was the account created in your DB then it was me then i went for your billing server and deleted TB_User and crashed your mySQL server.