On Thu, 2010-06-10 at 23:18 -0400, Tom Lane wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> > On Thu, Jun 10, 2010 at 5:54 PM, Jim Nasby <jim(at)nasby(dot)net> wrote:
> >> So there's no way to see if a particular privilege has been granted to public. ISTM 'public' should be accepted, since you can't use it as a role name anyway...
> > It's a bit sticky - you could make that work for
> > has_table_privilege(name, oid, text) or has_table_privilege(name,
> > text, text), but what would you do about the versions whose first
> > argument is an oid?
> Nothing. The only reason to use those forms is in a join against
> pg_authid, and the "public" group doesn't have an entry there.
ISTM this bug should be on the open items list...
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
In response to
pgsql-hackers by date
|Next:||From: Vik Reykja||Date: 2010-08-11 08:00:31|
|Subject: Re: Regression tests versus the buildfarm environment|
|Previous:||From: Marko Tiikkaja||Date: 2010-08-11 07:54:00|
|Subject: Re: assertions and constraint triggers|