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