update schema table permission denied
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
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