title: Snowflake - Grant permissions by username
body: <p>I'm trying to restrict read permissions on some entities to a specific user.</p>
  <p>In Oracle I'd simply do</p>
  <pre><code>GRANT SELECT ON sensitive_schema.my_table1 TO error_2646;
  GRANT SELECT ON sensitive_schema.my_table2 TO error_2646;
  GRANT SELECT ON sensitive_schema.my_tableN TO error_2646;
  </code></pre>
  <p>or ideally at schema level</p>
  <pre><code>GRANT SELECT ON sensitive_schema TO error_2646;
  </code></pre>
  <p>Can I do this in Snowflake? In the documentation it looks like permissions are managed by role in Snowflake and I'd rather not change this person's role.</p>
  <p><a href="https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html" rel="nofollow noreferrer">https://docs.snowflake.com/en/sql-reference/sql/grant-privilege.html</a></p>