title: SQL Server 2008 - Does a trigger run with the same permissions as the login/user?
body: <p>Just a quick question:</p>
  
  <p>Say I put an insert trigger on a table in my database.</p>
  
  <p>If data is inserted into that table through a login/user "foobar".</p>
  
  <p>Does the trigger execute with the same access rights / permissions as "foobar"?</p>
  
  <p>Many thanks.</p>