title: Implementing row based access based on role
body: <p>I have created a table that contains Ticket information, with an id, message body, user id and department id. </p>
  
  <p>I would like to be able to limit access to these tickets, such that only users from the corresponding department can access the relevant tickets, and can not view other department's tickets. </p>
  
  <p>I have attempted to make an updatable view for each department and granting select on this, but it does not work very well. </p>
  
  <p>Is there a simple way to achieve this kind of role based access?</p>