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