Re: system administration functions with hardcoded superuser checks

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: system administration functions with hardcoded superuser checks
Date: 2013-01-15 14:25:40
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 12/18/12 12:09 PM, Peter Eisentraut wrote:
> There are some system administration functions that have hardcoded
> superuser checks, specifically:
> pg_reload_conf
> pg_rotate_logfile
> pg_read_file
> pg_read_file_all
> pg_read_binary_file
> pg_read_binary_file_all
> pg_stat_file
> pg_ls_dir
> Some of these are useful in monitoring or maintenance tools, and the
> hardcoded superuser checks require that these tools run with maximum
> privileges. Couldn't we just install these functions without default
> privileges and allow users to grant privileges as necessary?

This is still being debated, but just for the heck of it, here is a
patch for how this implementation would look like.

Attachment Content-Type Size
pg-func-superuser-checks.patch text/plain 3.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2013-01-15 14:43:04 Re: strange OOM errors with EXECUTE in PL/pgSQL
Previous Message Alvaro Herrera 2013-01-15 14:21:05 Re: recent ALTER whatever .. SET SCHEMA refactoring