How to disable record delete by login
Posted on 2005-04-21
I am sure there is an easy way to do this but I can not find it.
I need to disable the delete record capabilty for specific users in a single table. Delete needs to remain intact for other tables in the database. I have tried the obvious of changing the permissions for the user on the table by checking the boxes for SELECT, INSERT and UPDATE only. DELETE is left unchecked. It seems that this user can still DELETE records from this table.
In looking at the permissions, it seems that for every table none of the options (select, insert, update, delete, exec and dri) are checked. Am I missing something in my SQL Server setup?
Let me know if there is additional information needed to answer this question.