Remove superuser() checks from pgstattuple

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Remove superuser() checks from pgstattuple
Date: 2016-08-23 21:22:43
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


Attached is an rebased and updated patch to remove the explicit
superuser() checks from the contrib extension pgstattuple, in favor of
using the GRANT system to control access, and give the admin flexibility
to GRANT access to this function without having to write wrapper
functions, similar to what was been done with the backend functions.

This, naturally, REVOKE's EXECUTE from public on installation for these

Prior discussion was on this thread:


but it seemed prudent to open a new thread, to avoid anyone missing that
this isn't about default roles (which was the subject of that thread).



Attachment Content-Type Size
pgstattuple-remove-superuser-checks_v3.patch text/x-diff 23.3 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2016-08-23 21:41:43 Re: dump/restore doesn't preserve row ordering?
Previous Message Tom Lane 2016-08-23 21:22:03 dump/restore doesn't preserve row ordering?