test...@workbook=# select has_table_privilege( 'public', 'test', 'SELECT' ); ERROR: role "public" does not exist test...@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...@workbook=# create role public; ERROR: role name "public" is reserved test...@workbook=# create role "public"; ERROR: role name "public" is reserved -- Jim C. Nasby, Database Architect j...@nasby.net 512.569.9461 (cell) http://jim.nasby.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers