title: Grant all on a specific schema in the db to a group role in PostgreSQL
body: <p>Using PostgreSQL 9.0, I have a group role called "staff" and would like to grant all (or certain) privileges to this role on tables in a  particular schema. None of the following work</p>
  
  <pre><code>GRANT ALL ON SCHEMA foo TO staff;
  GRANT ALL ON DATABASE mydb TO staff;
  </code></pre>
  
  <p>Members of "staff" are still unable to SELECT or UPDATE on the individual tables in the schema "foo" or (in the case of the second command) to any table in the database <em>unless</em> I grant all on that specific table.</p>
  
  <p>What can I do make my and my users' lives easier?</p>
  
  <p><strong>Update:</strong> Figured it out with the help of <a href="https://serverfault.com/questions/60508/grant-select-to-all-tables-in-postgresql">a similar question on serverfault.com</a>.</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA foo TO staff;
  </code></pre>