Olivier PRENANT <ohp@pyrenet.fr> writes:
> Shoudn't postgres extend priviledges to the sequences generated by a
> create table ???
That's not clear. The sequence is an independent object. Had you
explicitly done
CREATE SEQUENCE myseq;
CREATE TABLE mytab (f1 int default nextval('myseq'));
would you expect that granting permissions on mytab automatically
grants them on myseq as well? I think you might consider that
surprising. But there isn't any difference between this and what
CREATE TABLE does.
There have been suggestions in the past that SERIAL should be a "real
data type" with the sequence object being hidden more effectively than
it is now --- including auto-dropping it at table deletion, etc.
If that were to happen then the permissions issue would probably go away
too. It doesn't seem to be a very high priority for anyone, though.
regards, tom lane
