multiple databases- MySQL
Posted by: geoffdougherty
Posted on: 2005-08-22 18:00:00
So here's my problem: I have some news content in one table and some forum postings related to the news content in another table.
I need to set things up so that I can query and display news content and the related forum comments.
But I don't want my forum users to be able to access the news table.
So I need to find a way to either a) put these two tables in the same database with a user scheme that allows a user to write to the forum table but read-only the news table; b) keep the tables in separate databases to control access, but write a join query to link the related forum and news items; or c) find another solution that I haven't thought of.
Any ideas?
Thanks.