(absolutely) read only records
I have a database that logs transactions. Every time a transaction is logged that is an absolute event. ie it will never be modified or deleted.
How do I lock that record so no-one, script or admin or user can modify or delete it (without modifying the database structure)?
This seems such a simple thing to want to do but the only solutions I can find are convoluted application of privileges which still allow modification.