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.
I've seen solutions for 9.0 but I'm stuck with 8.4 as it ships with Debian stable.
I have tried the following as a baseline but it doesn't work, resulting in the inevitable "access to relation X denied":
GRANT ALL PRIVILEGES ON DATABASE testdb TO testuser;
I've dredged through the documentation and I can't seem to find a suitable solution.