title: Failing to grant select on a specific schema's table in redshift
body: <p>I want a user I have created in <code>redshift</code> to have only <code>SELECT</code> grant on a specific table (<code>mytable</code>) of a specific schema (<code>myschema</code>).</p>
  <p>I have already created the user <code>myser</code>, however the following command fails:</p>
  <pre><code>mydb=# GRANT SELECT ON TABLE mytable IN SCHEMA &quot;myschema&quot; TO myuser;
  ERROR:  syntax error at or near &quot;IN&quot;
  </code></pre>
  <p>Any suggestions?</p>