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?
Thanks