Password for Tables?

Hi,

Is there way to assign passwords to individual users for specific tables in a mysql database? I am not root: I have access to a database via a webhosting service.

I want to create an e-commerce site using php3 forms that dump into a mysql database. And I want to allow the users, these will be company's wanting data from RFQ's & PO's customers have submitted, I want to grant these users access to particular tables.

Can I do that?

Thanks in advance...


-- Kyoko

No. But you can grant access to individual records. Each record is "owned" by a particular user. Just make a field with that users id. You'll need session management.

Then when you query, make that customer's id part of the query.