Adrian Klaver <adrian.klaver@gmail.com> writes:
> On Monday, February 28, 2011 8:02:53 am Tom Lane wrote:
>> Right. But actually, that query will be run with the permissions of the
>> owner of the table, so it's that user (not necessarily the one doing the
>> INSERT) who lacks permissions.
> The OP listed the permissions for the tables:
> spam=> \z out2cp
> Access privileges for
> database "spam"
> Schema | Name | Type |
> Access privileges
>
--------+--------+-------+-------------------------------------------------------------------------------------------------------
> public | out2cp | table |
> {swcoll=r/petrcech,swcgi=r/petrcech,spamdump=r/petrcech,facility=r/petrcech,borelupo=arwdxt/petrcech}
> (1 row)
> Looks like borelupo is owner of permout and has permissions on out2cp.
But what matters is the permissions of the owner of out2cp, which looks
from this to be petrcech. And I don't see that he's granted himself
any permissions.
regards, tom lane