title: Mysql users can select from tables but not views
body: <p>I have a mysql database on which I create users, and grant them select, update, insert and delete on a particular database.</p>
  
  <p>The database contains both tables and views. For some reason these created users get the following error when trying to select from a view.</p>
  
  <pre><code>Access denied for user 'someuser'@'%' (using password: YES)
  
  SELECT * FROM (`someview`) WHERE `somecolumn` = 0
  </code></pre>
  
  <p>I don't however get this error when selecting from a table in the same database.</p>
  
  <p>I have deployed this application to multiple places and it's working everywhere else including using amazon rds. this particular instance is a mysql server running on amazon ec2.</p>