I was curious to know is there a way to lock tables to read only. I know that you can restrict a user to select priv's or you can lock a table for your current thread. Though if you do not unlock the table and leave your mysql session the table automatically comes unlock. I would like a table to only be read only without losing it in a transaction, thread, or having a seperate user. Is there a way to do it with alter because I can't find it anywhere or know of any idea to do it. I am using MyISAM storage engine.