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