Excerpts from Jim Nasby's message of jue jun 10 17:54:43 -0400 2010:
> test_us(at)workbook=# select has_table_privilege( 'public', 'test', 'SELECT' );
> ERROR:  role "public" does not exist

Here's a patch implementing this idea.

I'm not too sure about the wording in the doc changes.  If somebody
wants to propose something better, I'm all ears.  To facilitate
bikeshedding, here's a relevant extract:

	has_table_privilege checks whether a user can access a table in
	a particular way. The user can be specified by name; as public,
	to indicate the PUBLIC pseudo-role; by OID (pg_authid.oid), or,
	if the argument is omitted, current_user is assumed.

(the first appearance of public is <literal>public</>.  I had first made
it <quote> but that didn't feel right.)

Another thing that could raise eyebrows is that I chose to remove the
"missing_ok" argument from get_role_oid_or_public, so it's not a perfect
mirror of it.  None of the current callers need it, but perhaps people
would like these functions to be consistent.

-- 
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

• Bug / shortcoming in has_*_privilege at 2010-06-10 21:54:43 from Jim Nasby

Responses

• Re: Bug / shortcoming in has_*_privilege at 2010-09-06 21:31:12 from Tom Lane
• Re: Bug / shortcoming in has_*_privilege at 2010-10-05 04:06:05 from KaiGai Kohei
• Re: Bug / shortcoming in has_*_privilege at 2010-10-13 02:05:36 from Itagaki Takahiro

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2010-09-06 21:31:12
	Subject: Re: Bug / shortcoming in has_*_privilege
Previous:	From: Tom Lane	Date: 2010-09-06 21:03:38
	Subject: Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)