I have a question about database access in mysql on DH. Here is the scenario:
We have a site with an ASP model that stores information about users, real estate properties, and related info. The property specific stuff is broken out by userids so that we can pull information that applies to a specific client.
Ideally I want to make some sort of a webservice in php that will generate an xml string that is client specific based on the id that is passed to this page. On the client sites I’ll have a simple php page that can parse the xml and load it into php objects. I don’t have much of any XML experience unfortunately so this is going to be an uphill battle.
In the mean time I was thinking about simply adding a read-only password that would allow the client sites to query the database directly. When setting the new mysql account up it looks like I can only apply permissions at the database level and not at the table level. This doesn’t work so good because I wouldn’t want that account to read the user data. Is there any way that these permissions can be set on individual tables or is that not something I can do on the shared host? Any input would be appreciated.