title: MVC2 C# Restricting Access to a view based on an ID
body: <p>I have two tables one with jobs one with managers, when a job ID is passed to the view 'Detail' the details of that job are accessible.</p>
  
  <pre><code>Job_id  Job_Title       Manager_id
  23      Chimney Sweep   65
  24      Rat Catcher     84
  
  Managers    Email
  65          arthur@work.com
  66          fred@work.com
  </code></pre>
  
  <p>I want to restrict access to the view based on the manager_email - so for example if we're on <a href="http://jobsite/jobs/Detail/23" rel="nofollow">http://jobsite/jobs/Detail/23</a> then only arthur can access the view.. will be using AD to pick out the user's email..</p>
  
  <p>Any pointers would be much appreciated!</p>