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

Re: Permission Problem for DELETE

From: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Permission Problem for DELETE
Date: 2008-05-27 11:51:53
Message-ID: 87wslg7yna.fsf@alamut.mobiliz.com.tr (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, 27 May 2008, Volkan YAZICI <yazicivo(at)ttmail(dot)com> writes:
> PostgreSQL doesn't allow me to DELETE a row from
> commsrv.outgoingmessages with emove role.

By the way, I just learnt that I cannot do INSERT too.

  (emove(at)192(dot)168(dot)1(dot)160:5432/test_1_5_0_0) [2008-05-27 14:47:01]
  > INSERT INTO commsrv.outgoingmessages
         SELECT messageid+1, vendorid, ...
           FROM commsrv.outgoingmessages
       ORDER BY messageid DESC
          LIMIT 1;
  ERROR:  permission denied for relation outgoingmessages

I suspected, schema permissions first...

  (emove(at)192(dot)168(dot)1(dot)160:5432/test_1_5_0_0) [2008-05-27 14:46:58]
  > \dn+ commsrv
                                List of schemas
    Name   | Owner |             Access privileges              | Description
  ---------+-------+--------------------------------------------+-------------
   commsrv | test  | {test=UC/test,commsrv=U/test,emove=U/test} |

But this doesn't look like to be the case.

Does anybody have an idea? What might I be missing? I'll be really
really appreciated for any kind of help.


Regards.

In response to

pgsql-general by date

Next:From: Jonathan Bond-CaronDate: 2008-05-27 12:26:29
Subject: Re: New MS patent: sounds like PG db rules
Previous:From: A. KretschmerDate: 2008-05-27 11:44:16
Subject: Re: New MS patent: sounds like PG db rules

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