Write once, read many mysql fields

Question

Can you restrict updating a field without granting additional user rights?

Basically, a value in a string can only be set during an insert statement.

Answer 1

You can use the update trigger to prevent the value from updating.

Answer 2

Yes. If you grant only insert and select privileges. How:

 grant select, insert, update(message, time) on hibtest.message to 'worm'@'localhost' identified by 'worm' 

... that way, the user can update the message and time columns.

Answer 3

Mysql distinguishes between insert privileges and update privileges, which will give the user the ability to insert, but not upgrade later.

see this link: http://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html

Answer 4

Not suitable for your question: if you run mysqlisampack in a table, the table will become read-only.

This is good if you have a datawharehouse, which is just a link, but not very good if you just want to make a live column read-only.