Bug / shortcoming in has_*_privilege

Jim Nasby <jim@nasby.net>

From: Jim Nasby <jim@nasby.net>
To: PGSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-06-10T21:54:43Z
Lists: pgsql-hackers
test_us@workbook=# select has_table_privilege( 'public', 'test', 'SELECT' );
ERROR:  role "public" does not exist
test_us@workbook=# 

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...

test_us@workbook=# create role public;
ERROR:  role name "public" is reserved
test_us@workbook=# create role "public";
ERROR:  role name "public" is reserved
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net