Hi Tom,
Thanks for your quick reply. However, I knew (and did that). My post were
more ... philosophical:
Shoudn't postgres extend priviledges to the sequences generated by a
create table ???
Regards,
On Fri, 11 May 2001, Tom Lane wrote:
> Olivier PRENANT <ohp@pyrenet.fr> writes:
> > I've just noticed that (after a upgrade from 7.0.3 to 7.1) the following
> > did'nt work anymore:
>
> > create tabla a (n1 serial, n2 int);
> > grant all on a to nobody;
>
> > <reconnect as user nobody>
>
> > insert into a (n2) value (1);
> > n1.nextval: you don't have permission to set sequence n1
>
> > It worked on 7.0.3
>
> You'll have to grant update rights on the sequence object to nobody ...
>
> regards, tom lane
>
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)