Remove superuser() checks from pgstattuple - Mailing list pgsql-hackers

From Stephen Frost
Subject Remove superuser() checks from pgstattuple
Date
Msg-id 20160823212243.GJ4028@tamriel.snowman.net
Whole thread Raw
Responses Re: Remove superuser() checks from pgstattuple  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List 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.GQ10850@tamriel.snowman.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: dump/restore doesn't preserve row ordering?
Next
From: Andres Freund
Date:
Subject: Re: dump/restore doesn't preserve row ordering?