title: PostgreSQL: Give all permissions to a user on a PostgreSQL database
body: <p>I would like to give a user all the permissions on a database without making it an admin.
  The reason why I want to do that is that at the moment DEV and PROD are different DBs on the same cluster so I don't want a user to be able to change production objects but it must be able to change objects on DEV.</p>
  <p>I tried:</p>
  <pre><code>grant ALL on database MY_DB to group MY_GROUP;
  </code></pre>
  <p>but it doesn't seem to give any permission.</p>
  <p>Then I tried:</p>
  <pre><code>grant all privileges on schema MY_SCHEMA to group MY_GROUP;
  </code></pre>
  <p>and it seems to give me permission to create objects but not to query\delete objects on that schema that belong to other users</p>
  <p>I could go on by giving USAGE permission to the user on MY_SCHEMA but then it would complain about not having permissions on the table ...</p>
  <p>So I guess my question is: is there any easy way of giving all the permissions to a user on a DB?</p>
  <p>I'm working on PostgreSQL 8.1.23.</p>