Re: Permission denied when inserting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: adrian(dot)klaver(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org, Vick Khera <vivek(at)khera(dot)org>, Borek Lupomesky <borek(at)lupomesky(dot)cz>
Subject: Re: Permission denied when inserting
Date: 2011-02-28 16:17:07
Message-ID: 8215.1298909827@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Borek Lupomesky 2011-02-28 16:25:11 Re: Permission denied when inserting (SOLVED)
Previous Message Adrian Klaver 2011-02-28 16:09:37 Re: Permission denied when inserting