Cannot find the with options you gave, but I found this :

DROP TABLE #dbc

go

create table #dbc(c1 varchar(15), c2 int, c3 varchar(255))

insert #dbc EXEC('dbcc inputbuffer(7)')

wich works fine too

tnx anyway !

Figured it out meantime, thanks for the help!

yep, that's exactly what I did..made sure this user has no rights at all ! but still didn't work, made your idea of recreating this user helps, but just to...

well, for the first few weeks I would like to send me an e-mail, so I know when there is a delete action and on what time this happens, and...

nope, sql authentication, no windows authentication.

I was thinking of an INSTEAD OFF trigger..is there any difference with your suggestion ? what is best ?

Deny permission is set for all users, still my user can delete on the table, after your message I unchecked the SA role for this user, but still same result.

When...