pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedupdate 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>
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:22 Tom Lane <tgl@sss.pgh.pa.us>
parent: Vano Beridze <vanuatoo@gmail.com>
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