Re: update schema table permission denied

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vano Beridze <vanuatoo(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: update schema table permission denied
Date: 2024-02-02 22:22:28
Message-ID: 3308786.1706912548@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vano Beridze <vanuatoo(at)gmail(dot)com> writes:
> I granted insert and update permission on the table outbox_event to the
> user "app"
> When the following command is run with the user app
> update adm.outbox_event set .. where id = ..
> Postgresql gives the notification:
> ERROR: permission denied for table outbox_event

You need SELECT privilege too in order to read the "id" column.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-02-03 01:15:39 Re: vacuum freeze wait_event BufferPin
Previous Message Vano Beridze 2024-02-02 22:18:19 update schema table permission denied