title: postgres table privileges do not allow user to create/select view
body: <p>I am managing a database that has a number of schemas. I am having some difficulty with setting privileges and would like to request some help. </p>
  
  <p>I have the schema called <em>schemaA</em> and a group_role <em>db_writer</em></p>
  
  <p>I use the following sql:</p>
  
  <pre><code>GRANT USAGE ON SCHEMA schemaA TO db_writer;
  GRANT UPDATE, INSERT, SELECT, DELETE ON ALL TABLES IN SCHEMA schemaA TO db_writer;
  </code></pre>
  
  <p>However, the db_writer is unable to create views. They are returned with a permission denied error. Also, when I create views, she is then unable to select them...and I have to set the priviliges again for that view. </p>
  
  <p>It was my understanding the views were treated as tables with respect to privileges...and if one is granted certain permissions to all tables in a schema this would apply to views also.</p>
  
  <p>What am I missing? Any advice appreciated. </p>