homepage Welcome to WebmasterWorld Guest from 54.166.96.101
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Read only mysql tables
Sansovino



 
Msg#: 4282860 posted 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

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



 
Msg#: 4282860 posted 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

WebmasterWorld Senior Member rocknbil us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4282860 posted 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



 
Msg#: 4282860 posted 9:21 am on Apr 27, 2011 (gmt 0)

Thanks - I'll try that.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved