title: Sql Server: how to write trigger on a table with denied SELECT
body: <p>Hello I have a table on which I have denied SELECT privs to a user.<br>
  This table has a trigger which references the INSERTED table, basically doing an </p>
  
  <pre><code>AFTER UPDATE SET &lt;table&gt;.[UPDATED] = getdate() 
    WHERE ROWID IN SELECT ROWID FROM INSERTED
  </code></pre>
  
  <p>It is giving me an error though, saying "SELECT PERMISSIONS DENIED", I am guessing because of the SELECT FROM INSERTED. </p>
  
  <p>How can I keep the SELECT deny, but allow the trigger to SELECT from the INSERTED pseudotable? </p>
  
  <p><strong>Thanks in advance!</strong> </p>