On Thu, Jan 05, 2006 at 11:44:24 -0800,
  Josh Berkus <josh@agliodbs.com> wrote:
> Bruce, Tom,
> > > The permissions for a sequence aren't the same as they are for a
> > > table. We've sort of ignored the point to date, but if we're going to
> > > add special syntax for granting on a sequence, I don't think we should
> > > continue to ignore it.
> >
> > Uh, how are they different?   You mean just UPDATE and none of the
> > others do anything?
> Yes, it would be nice to have real permissions for sequences, specifically 
> USE (which allows nextval() and currval()) and UPDATE (which would allow 
> setval() ).   However, I don't know that the added functionality would 
> justify breaking backwards-compatibility.

It might be nice to split nextval and currval access as well. nextval access
corresponds to INSERT and currval access to SELECT.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to