title: GRANT syntax for domain\user
body: <p>I'm trying to give access to an active directory user to only one specific table. I want them to be able to insert, update, delete, etc. but only for that table. I know this command:</p>
  
  <pre><code>GRANT Insert, Select on Tablename to user
  </code></pre>
  
  <p>But I can't figure out how to get "domain\user" to work syntax-wise. I tried:</p>
  
  <pre><code>GRANT Insert, Select on Tablename to domain\user
  </code></pre>
  
  <p>But I get:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1<br>Incorrect syntax near '\'.</p>
  </blockquote>