Read only mysql tables

[Sansovino]

Hi,

is it possible to set some tables in a mysql database to read only while others are still writable?

Thanks

[coopster]

Welcome to WebmasterWorld, Sansovino.

Have you read through The MySQL Access Privilege System [dev.mysql.com] and Account Management Statements [dev.mysql.com]?

There is a lot of detail regarding database connection, database and table security and user-level security. You may want to start there.

[rocknbil]

One way is to connect using two users, assign read only privileges to the "public" user, write privileges to the "admin" user.

[Sansovino]

Thanks - I'll try that.