title: Grant select to all tables except Table1
body: <p>I am using MySQL 5.5.42 in Linux.</p>
  
  <p>Could I grant SELECT to User1 on all tables in Database1 except Table1 ?</p>
  
  <p>This is because Table1 contain sensitive data and User1 is not allow to read.</p>
  
  <p>For other users, I can easily grant select on Database1.*</p>
  
  <p>For User1, I have to grant select on Dataabse1.Table2, Table3, Table4, Table5, ...</p>
  
  <p>This is quite a trouble, especially when adding new tables to Database1.</p>
  
  <p>Is there any other quicker method ?</p>
  
  <p>Many thanks.</p>
  
  <p>Alvin SIU</p>