title: SQL permissions for roles
body: <p>I'm a bit confused about permissions in SQL</p>
  
  <p>I have created a medical database.</p>
  
  <p>As a script I'm creating a doctor role and I want to say they can perform updates on tables 1,2 and 3.</p>
  
  <p>The database though actually contains 5 tables.</p>
  
  <p>does it mean that they wont be able to update 4 and 5 ?</p>
  
  <p>or will i have to explicitly say deny update on tables 4 and 5 for the doctor role ?</p>