I'm stuck.
How do I grant select, insert, delete, update rights to an entire database?
I tried this:
GRANT SELECT, INSERT, UPDATE, DELETE ON DATABASE foo TO bar;
and it returns
ERROR: syntax error at or near "INSERT" at character 14
I'm just not getting it, it sure looks like I should be able to.
I'm logged in as postgres.