title: The SELECT permission was denied
body: <p>My query:</p>
  
  <pre><code>update sc 
  set grade = 80
  where grade = 90
  </code></pre>
  
  <p>results in this error:</p>
  
  <blockquote>
    <p>Msg 229, Level 14, State 5, Line 1<br>
    The SELECT permission was denied on the object 'sc', database 'student', schema 'dbo'.</p>
  </blockquote>
  
  <p>I have typed this, and it get worked</p>
  
  <pre><code>grant UPDATE (grade) on sc to MyUserName
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/ISnhy.png" alt="enter image description here"></p>