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.

			regards, tom lane

In response to

• Re: Bug / shortcoming in has_*_privilege at 2010-06-11 00:46:33 from Robert Haas

Responses

• Re: Bug / shortcoming in has_*_privilege at 2010-07-02 15:11:41 from Nasby, Jim
• Re: Bug / shortcoming in has_*_privilege at 2010-08-11 07:57:24 from Simon Riggs

pgsql-hackers by date

Next:	From: Peter Eisentraut	Date: 2010-06-11 04:00:48
	Subject: Re: LLVM / clang
Previous:	From: Fujii Masao	Date: 2010-06-11 02:40:34
	Subject: Re: ps display "waiting for max_standby_delay"