Re: update schema table permission denied - Mailing list pgsql-general

Vano Beridze <vanuatoo@gmail.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