Welcome to WebmasterWorld Guest from 54.158.228.55

Forum Moderators: open

Message Too Old, No Replies

Read only mysql tables

     
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
1:00 pm on Mar 17, 2011 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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.
3:59 pm on Mar 17, 2011 (gmt 0)

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member



One way is to connect using two users, assign read only privileges to the "public" user, write privileges to the "admin" user.
9:21 am on Apr 27, 2011 (gmt 0)



Thanks - I'll try that.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month