Re: Required permissions for data directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Required permissions for data directory
Date: 2004-10-12 19:31:58
Message-ID: 5858.1097609518@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> Tom Lane wrote:
>> Being able to edit postgresql.conf gives one the ability to become
>> postgres (hint: you can cause the backend to load a shlib of your
>> choosing, or even more trivially, adjust pg_hba.conf to let you in
>> as superuser), so the above distinction is unenforceable.

> Again, the responsibility of the administrator for the system.

How so? The point is that there is *no such thing* as giving someone
config edit permissions without thereby implicitly trusting them with
the keys to the city. If you trust them that much, you may as well let
them su to postgres. There is no point in using group membership as a
substitute.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2004-10-12 19:46:18 Re: Cannot build latest snapshot under Mingw
Previous Message Tom Lane 2004-10-12 19:26:48 Re: Required permissions for data directory