Re: What permissions are required for e.g. EXPLAIN UPDATE ...

2024-04-04 Thread Tom Lane
Thomas Nyberg writes: > 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? IIRC, the reasoning is this: should you be allowed to run an EXPLAIN on a table that you have no permissions for at all?

What permissions are required for e.g. EXPLAIN UPDATE ...

2024-04-04 Thread Thomas Nyberg
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 requir