Is it possible to have a mysql database where either:
a) the user has limited permissions on a table by table basis (e.g. can only select, insert from table_a, and can only update table_b)
b) permissions can be assigned to a table so that table_a cannot be updated.
if either of these options are possible, does anybody know of a web host which will allow me to do this as my current host won't (they say it is something to do with limiting the number of mysql requests).
I need for table_b to be updated to provide content for the website (it gets its data from table_a) but i need to ensure that the data in table_a cannot be updated to preserve it's accuracy.
i have considered moving table_b to another database and taking away the users permission to update the original database but this seems like a workaround rather than a fix, and would require me to make multiple connections to the databases in order to update table_b.
If anybody has any alternative solutions to this, then I'd be very grateful.