Read only mysql tables

Forum Moderators: open

Message Too Old, No Replies

Read only mysql tables

Sansovino

8:38 am on Mar 17, 2011 (gmt 0)

Hi,

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

Thanks

coopster

1:00 pm on Mar 17, 2011 (gmt 0)

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

3:59 pm on Mar 17, 2011 (gmt 0)

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

Sansovino

9:21 am on Apr 27, 2011 (gmt 0)

Thanks - I'll try that.