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