Bug / shortcoming in has_*_privilege

From: Jim Nasby <jim(at)nasby(dot)net>
To: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug / shortcoming in has_*_privilege
Date: 2010-06-10 21:54:43
Message-ID: 4399EF7A-9419-4F84-B51A-A55C5EFAC12A@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

test_us(at)workbook=# select has_table_privilege( 'public', 'test', 'SELECT' );
ERROR: role "public" does not exist
test_us(at)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(at)workbook=# create role public;
ERROR: role name "public" is reserved
test_us(at)workbook=# create role "public";
ERROR: role name "public" is reserved
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2010-06-10 21:58:06 Re: Idea for getting rid of VACUUM FREEZE on cold pages
Previous Message Greg Smith 2010-06-10 21:34:29 Re: fix use of posix_fadvise in xlog.c