grant user access - Mailing list pgsql-general

From Tom Allison
Subject grant user access
Date
Msg-id 40F9D485.8040104@tacocat.net
Whole thread Raw
Responses Re: grant user access
List pgsql-general
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.


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: URGENT pg_xlog full impossible to restart ...
Next
From: Tom Lane
Date:
Subject: Re: URGENT pg_xlog full impossible to restart ...