What is wrong with the following statement?
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO foo;
I get this error
ERROR: syntax error at or near "ALL"
LINE 2: ON ALL TABLES IN SCHEMA public TO foo;
I am using postgreSQL 8.3 on Ubuntu.