Postgres Pro
Downloads
Home   >   mailing lists

update schema table permission denied - Mailing list pgsql-general

From Vano Beridze
Subject update schema table permission denied
Date
Msg-id CANmF5MA9mS-d5=nBH1a4REZ7Rkt2-wmO8o+miNSLCD=JpZuZvg@mail.gmail.com
Whole thread Raw
Responses Re: update schema table permission denied  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: abrahim abrahao
Date:
Subject: Re: vacuum freeze wait_event BufferPin
Next
From: Tom Lane
Date:
Subject: Re: update schema table permission denied