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
Message-ID: 20160823212243.GJ4028@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

Greetings,

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
functions.

Prior discussion was on this thread:

20160408214511(dot)GQ10850(at)tamriel(dot)snowman(dot)net

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).

Thanks!

Stephen

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

Responses

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?