Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group