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
DoNotChangeMe;

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

Thanks,
Steve