title: Grant a user permission to only view a MySQL view and nothing else
body: <p>This question was originally using MySQL 5.1.44, but is applicable to MySQL 8.0+ too.</p>
  <p>Let's say I have a table with records inserted by different users of my application. How can I give a specific user access to only see his/her records in that table? I've thought about creating a <code>VIEW</code> with his/her records, but I  don't know how to create a MySQL user that can only see that <code>VIEW</code>.</p>
  <p>So, is it possible to create a MySQL user that only has access to a single <code>VIEW</code>? Can this user also be made so they read-only access to that <code>VIEW</code>?</p>
  <p>Thanks!</p>
  <p>PS: What I call <em>users</em> in my example are really subsidiary offices that want to access their records with their own applications.</p>