What is the best way to prevent a user from deleting records in a particular table?

We have a user which has full access to a particular database, but in this instance, we want to prevent that user from being able to delete records of a particular table. Inserts and updates are OK.

Is it just a matter of granting the specific permissions on the table itself and excluding the ones you don’t want?


AFAIK you can’t revoke rights on a lower level that has been given on a higher.

But if you give that user all rights except delete on the DB level and then give the user the delete rights on the table level for all tables except the one you don’t want him to be able to delete from.