Re: Permission denied for sequece...

On Mon, 2006-08-21 at 17:27, Jon Horsman wrote:
> > Column | Type | Modifiers
> > --------+---------+------------------------------------------------------
> > id | integer | not null default nextval('public.real_id_seq'::text)
> >
> > Note that my table, real, has a sequence named read_id_seq. You need to
> > grant all on that as well...
>
> That did it. Thanks a lot. I _never_ would have guessed that and
> don't recall seeing it in the docs, perhaps i missed it.

I do think it's in the docs, but I'm not prepared to bet on it. :) It
is a rather inobvious thing though.

> While on the topic. Is there one blanket command that can be run to
> grant the user permissions to do everything to the db, without making
> that user the owner or a superuser?

No, there is no single statement. But there is pl/pgsql. If you search
the archives there are examples of some fairly simple pl/pgsql scripts
that do just that. There might be provisions for such a built in in
8.2, due out soon. I haven't kept up on new pgsql development since
taking a rather busy job working on 7.4 machines. I'm really hoping to
get an 8.1/8.2 server up and running for work here as a data warehouse
though...