pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
update schema table permission denied
2+ messages / 2 participants
[nested] [flat]

* update schema table permission denied
@ 2024-02-02 22:18 Vano Beridze <vanuatoo@gmail.com>
  2024-02-02 22:22 ` Re: update schema table permission denied Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Vano Beridze @ 2024-02-02 22:18 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: update schema table permission denied
  2024-02-02 22:18 update schema table permission denied Vano Beridze <vanuatoo@gmail.com>
@ 2024-02-02 22:22 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2024-02-02 22:22 UTC (permalink / raw)
  To: Vano Beridze <vanuatoo@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-02-02 22:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-02-02 22:18 update schema table permission denied Vano Beridze <vanuatoo@gmail.com>
2024-02-02 22:22 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox