title: Is there a future in MySQL that limits the user based on column value?
body: <p>I have designed a CRM system with multiple clients level. Each table of my database has a column called "client_id" some people have access to some client_id's but not others. I am able to restrict this data that a user can see by simply adding a where clause "WHERE client_Id IN(1,2,3)"</p>
  
  <p>I was wondering if there is a way for this restriction to be done at the database level or if there is a middle man software that help me with this.</p>
  
  <p>This will give me an additional layer of security to who can see what. So if a hacker was able to changed 1,2,3 to 1,2,3, 4, 5 then the second level will prevent him from viewing data that belongs to client_id 4, 5.</p>
  
  <p>Or if I want to give a user access to the database using MySQL workbench, is it possible that he can be restricted from seeing data that belong to other clients?</p>
  
  <p>Is this possible? I use MySQL for a database but not sure if this is something that even exists in SQL regardless of the server type.</p>