| From: | Thomas Nyberg <twn(at)thomasnyberg(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | What permissions are required for e.g. EXPLAIN UPDATE ... |
| Date: | 2024-04-04 10:38:01 |
| Message-ID: | 485e4e3a-7c31-4d69-93e0-d5595256a197@thomasnyberg.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
Or put another way, does an EXPLAIN UPDATE on a table really require
UPDATE permissions to run? Why can't it be done without UPDATE
permissions? I can understand EXPLAIN ANALYZE UPDATE requiring it, since
it actually executes the statement, but why would a regular EXPLAIN
UPDATE require it? Is this documented somewhere in standard postgres
docs? The only answer I've been able to find on the internet is "The
user needs all privileges needed for the query that should be explained"
found here: https://stackoverflow.com/q/72984543
What does an EXPLAIN do exactly to require the extra permissions? I've
been searching the postgres documentation and the internet, but haven't
managed to find an answer.
Thanks for any help!
Cheers,
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Šindelář | 2024-04-04 13:42:36 | Re: ALTER SUBSCRIPTION ... REFRESH cannot be executed from a function |
| Previous Message | Tom Lane | 2024-04-04 05:54:04 | Re: Failure of postgres_fdw because of TimeZone setting |