# How to avoid security violation at table level **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [June 18, 2008, 2:50am UTC](https://forums.percona.com/t/how-to-avoid-security-violation-at-table-level/806 "2008-06-18T02:50:30Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![susheel](https://avatars.discourse-cdn.com/v4/letter/s/85f322/32.png) [@susheel](https://forums.percona.com/u/susheel)\ **Post date:** [June 18, 2008, 2:50am UTC](https://forums.percona.com/t/how-to-avoid-security-violation-at-table-level/806/1 "2008-06-18T02:50:30Z")
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. Regards Sus Moh ---
**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\ **Post date:** [June 19, 2008, 1:43am UTC](https://forums.percona.com/t/how-to-avoid-security-violation-at-table-level/806/2 "2008-06-19T01:43:15Z")
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. ---
**Author:** ![susheel](https://avatars.discourse-cdn.com/v4/letter/s/85f322/32.png) [@susheel](https://forums.percona.com/u/susheel)\ **Post date:** [June 19, 2008, 2:22am UTC](https://forums.percona.com/t/how-to-avoid-security-violation-at-table-level/806/3 "2008-06-19T02:22:40Z")
Thanks, for your timely and prompt suggestion. Regards sus moh