See http://www.postgresql.org/docs/7.4/static/sql-grant.html
Looks like you need something like GRANT ALL SELECT, ... ON DATABASE foo
To bar;
The below syntax is for table / view level grants.
Mike
On Sat, 2004-07-17 at 20:38, Tom Allison wrote:
> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org