title: How to use the SQL grant command to restrict access columns and rows in Access database
body: <p>I am beginner to this subject and self studying. I think this is basic but I could not find it in the ebook I am using. I do not know whether this is relevant to others because when I search this site all the questions are advance to me. So as a beginner, I thought to ask this again because last time my question was discarded as not relevant and not adequate research. I tried my best to find an answer browsing the net but came non. </p>
  
  <p>This is the table <code>INVENTORY (BOOK_CODE, BRANCH_NUM, ON_HAND)</code></p>
  
  <p>grant update on <code>INVENTORY</code> to Mark and this is the only way it explained in the pdf.</p>
  
  <p>This is the question I want to answer.
  Users Chambers must be able to change the units on hand for books in branch number 2 but must be unable to access data in any other branch.</p>
  
  <p>This is what I thought. </p>
  
  <pre><code>GRANT UPDATE ON(ON_HAND WHERE BRANCH_NUM = ‘2’) ON BRANCH TO CHAMBERS
  </code></pre>
  
  <p>is this correct?</p>
  
  <p>If you think this is not relevant to your community please discard.</p>