title: Postgres GRANT not applied on parent
body: <p>I'm in trouble with grant in postgresql (version 9.3).</p>
  
  <p>I'm trying to restrict a ROLE 'client_1'. I want it to be able to do only select for one table. But there is inheritance between tables.</p>
  
  <p>Here is my table structure:</p>
  
  <pre><code>CREATE TABLE public.table_a (...);
  CREATE TABLE table_a_partitions.child_1 (...) INHERITS (public.table_a);
  CREATE TABLE table_a_partitions.child_2 (...) INHERITS (public.table_a);
  
  GRANT SELECT ON table_a_child_1 TO client_1;
  </code></pre>
  
  <p>It's okay when I do a select on child_2, there is an error, but if I do a <code>SELECT * FROM table_a;</code> for example it also reads the forbidden table child_2. I would my client access only child_1 (and some other in the future) results when he does <code>SELECT * FROM table_a;</code>.</p>
  
  <p>Is there a simple way to solve this problem ?</p>
  
  <p>Thank you</p>