mySQL permissions ... a few newbie questions

[haggis-man]

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

[mwasif]

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).

No, you can not.If not, I guess I have to use separate tables or views for each user.
You are right, you have to use views.

[haggis-man]

Many thanks for that mwasif - I dropped off reading the mySQL documentation last night but had pretty much formed that opinion. Good to have it confirmed before setting myself unattainable goals. :)