title: PostgreSQL 8.4 grant DML privileges on all tables to a role
body: <p>How do I go about granting DML (SELECT,INSERT,UPDATE,DELETE) on all tables in a schema in PostgreSQL 8.4? I'd also like this grant to persist for new table creation in the future as well.</p>
  
  <p>I've seen solutions for 9.0 but I'm stuck with 8.4 as it ships with Debian stable.</p>
  
  <p>I have tried the following as a baseline but it doesn't work, resulting in the inevitable "access to relation X denied":</p>
  
  <pre><code>GRANT ALL PRIVILEGES ON DATABASE testdb TO testuser;
  </code></pre>
  
  <p>I've dredged through the documentation and I can't seem to find a suitable solution.</p>