update schema table permission denied

From: Vano Beridze <vanuatoo(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: update schema table permission denied
Date: 2024-02-02 22:18:19
Message-ID: CANmF5MA9mS-d5=nBH1a4REZ7Rkt2-wmO8o+miNSLCD=JpZuZvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-02-02 22:22:28 Re: update schema table permission denied
Previous Message abrahim abrahao 2024-02-02 20:25:27 Re: vacuum freeze wait_event BufferPin