From: | Olivier PRENANT <ohp(at)pyrenet(dot)fr> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Bug or feature? |
Date: | 2001-05-12 16:36:59 |
Message-ID: | Pine.UW2.4.21.0105121832180.5654-100000@server.pyrenet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)pyrenet(dot)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(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-12 16:48:19 | Re: Bug or feature? |
Previous Message | Tom Lane | 2001-05-12 16:35:32 | Re: Addition to: Trouble with initdb when the #define NAMEDATALEN = 51 |