Need data in tables to be read-only

[maxxximaniac]

Hey all, I need data in a table to be read only, once its inserted no one will be able to modify with the exception of a admin,
how can i go about doing this/.

thanks!

 

[alastair69]

You could setup a logn in system giving each user access rights.

 

[neileg]

Or split the database and keep people away from the back end. Then you control input and data reading via forms. The admin can have a separate front end that allows editing of the data.