Subject Trigger to prevent a deletion?
Author sgharp
Hi All,

I have some tables that contain records that the user should not be
able to modify or delete. Other records in the same table should be
freely modified, deleted, whatever. I'm trying to come up with
an 'on update or delete' trigger that will prevent the change if a
field value exists.

if (NEW.SomeField = 0) then

Is something like this possible from within a trigger or is there a
better way to protect these records at the server level?