title: PostgreSQL and GRANT statement
body: <p>I have n schemas on my PostgreSQL server (V9.2) and n users (1 user per schema). I just want to assign the privileges <code>SELECT, INSERT, UPDATE, DELETE, EXECUTE</code> for <code>user1</code> to <code>schema1</code>, for <code>user2</code> to <code>schema2</code>, for <code>usern</code> to <code>scheman</code> on each table.</p>
  
  <p>I can not do this with this statement :</p>
  
  <pre><code>GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON SCHEMA schema 1 to user1
  </code></pre>
  
  <p>because the clause <code>...ON SCHEMA</code> works only with <code>CREATE</code> and <code>USAGE</code> privileges.</p>
  
  <p>So what is the fastest way to assign all those privileges on each tables to concerned user please ? I hope the only way is not to do one <code>GRANT</code> statement per <code>schema.table</code>...?</p>