How to avoid security violation at table level

Hello all,

I have a huge table in which data of three clients are stored. I want to restrict one client to see the data of other two inorder to avoid security violation.
Does Mysql has any facility to do this at table level?

Please give me suggestions.

Sus Moh

You can add different access rights to different columns (see mysql.columns_priv table), but it’s not possible to have different access rights to different rows in one table (at least using built-in MySQL features).
Maybe you can add some extra level between clients and MySQL? Like some script, which will select only those rows which belong to specific client.

Thanks, for your timely and prompt suggestion.

sus moh