Обсуждение: update schema table permission denied

Поиск
Список
Период
Сортировка

update schema table permission denied

От
Vano Beridze
Дата:
Hello,

I've got a table outbox_event in schema adm
The owner of this table is some role
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

What could be the problem?

Version is 16.1

Kind regards,
Vano

Re: update schema table permission denied

От
Tom Lane
Дата:
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