Need SELECT rights to UPDATE/DELETE WHERE?

From: cpp(at)world-online(dot)no
To: pgsql-sql(at)postgresql(dot)org
Subject: Need SELECT rights to UPDATE/DELETE WHERE?
Date: 2005-01-27 15:46:25
Message-ID: 41C17A7100006F65@cpfe4.be.tisc.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

PostgreSQL 8.0.0 on WinXP Pro, libpq

In my hands it looks like a user with INSERT/DELETE/UPDATE rights on table1
cannot do "update table1 set field1=xx where field2=yy" without also being
granted select rights. However, the user can do "update table1 set field1=xx".
Is this right? Any explanations why it should be like this and any suggestions
on how to get around it without granting select is greatly appreciated.

KP

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-01-27 16:10:45 Re: What's the equivalent in PL/pgSQL
Previous Message Sean Davis 2005-01-27 15:07:26 Re: [SQL] URL activation through trigger