I haven't used the mySQL permissions mechanism to any great degree & could use a little help while still at the design stage.
Is it possible to grant certain users access only to certain RECORDS within a table (based on the value of a field in those records).
If not, I guess I have to use separate tables or views for each user.
Some initial guidance or links to reference material would be greatly appreciated. TIA
Edit: I am reading the manuals BTW - http://dev.mysql.com/doc/#manual